Google sheets to Power BI: New connector & schedule refresh

Microsoft just released a brand new connector that is super easy to use, this had been in the top 15 most voted for features on ideas.powerbi.com for some time so it's great that they finally brought in the feature. In this video I show how to connect to any Google Sheets file (business, consumer or free package),  you must log in with your credentials then you can work in Power Query and Power BI just like you would with any data from Excel. When you are done, I show how to publish to Power BI online and set up an auto-referesh schedule (no gateway required), Sheets may be the best source for an auto-refreshable dashboard/report, it's so quick, easy & hassle-free compared to other data sources (even OneDrive which is hard to work with a non-business account)

Note this feature is in Beta and I did notice some bugs that it asks to sign in a lot online so after I set up auto-fresh it failed a few times because it claimed I wasn't signed in, so I had to sign in again.

More info on the connector (The function is GoogleSheets.Contents) here: http://aka.ms/googlesheetsconnector

Table of Contents:

00:00 - Introduction
01:42 - Power Query data clean up
03:43 - Creating a parameter
04:51 - GoogleSheets Function
05:31 - Data modeling
07:18 - Schedule refresh
08:37 - Documentation
08:53 - Limitations

• #howto_style
• #google_sheets
• #import_data_google_sheets
• #google_sheets_tips_and_tricks
• #power_bi_data_sources
• #google_sheets_to_power_bi
• #publish_google_sheets_on_power_bi
• #use_power_bi_for_google_sheets_data