Forum Discussion
How to connect google sheet to Power BI
2023 update - the method below is no longer required, the native connector to Google Sheets is generally available. This supports Google authentication, so the data no longer needs to be public.
https://learn.microsoft.com/en-us/power-query/connectors/google-sheets
**** BELOW IS NOW OUT-OF-DATE ****
The easiest way is to Get Data / From Web, then enter the URL to your google sheet, with "&output=xls" on the end, e.g.
http://spreadsheets.google.com/pub?key=r1hlZB_n1rpXTij11Kw7lTQ&output=xls
PBI then analyses the resulting Excel file, showing the tabs as tables , which you can edit and manipulate.
Mike,
would you please help me locate the Get Data / From Web ...
Get data gives me the following options:
Import of Connect data
Files or Database
In database, I can't seem to find a way to paste a simple URL source. Thanks!!
Memorable Membergaillardb - It sounds like you are starting from app.powerbi.com ? I didnt make it clear, but actually my solution uses Power BI Desktop. That has much more "Get Data" functionality.
BTW these forums arent great - if you want someone to be notified of your reply you need to mention them eg @xyz