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.
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!!
gaillardb - 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
Mike,
I am affraid your option doesn't really work anymore. I haven't been able to do it.
Are you using the "shareable link" from google sheet, or the actual sheet URL ?
Thanks !
From Google Sheets, go to File / Publish to Web. Then change the selection from Web Page to Microsoft Excel. Copy the generated link.
What if I need protected source? In case of Publishing to the web any link owner can veiw data source. It seems not secured enough.
It only returns the first sheet? how do we get the other sheets?
Thanks for this! It works on my Google Spreadsheets.
Hello Mike,
Could you help me locate the basic Get data / From web in PowerBI. I am registered as a free user.
Thanks
How to get data from web in the Power BI pro (not desltop) ?????????
