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
How to reuse M functions:
How to create your own functions: