Get data from Google Sheets in Power Query
In today’s video I will show you how to import data from Google sheets/ Google Docs into Power BI manually.
Please note that there is a new Google Sheets connector not (in Beta at the time of writing) that might do what you need faster. If you still need to do it manually, here is how:
Watch the tutorial:

Links to the mentioned resources
Get Download #30 in the Community downloads folder at Curbal Download center
Link to my GitHub
Related material:
How to reuse M functions:

How to create your own functions:

Was this helpful?
Reader Interactions