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.
Hi,
I have copied doc link, but couldnt understand in Power Bi where do I need to past it. I mean which data connection I have to use to past this link ?
Hi RasikaOgale
I wasn't clear in my original post on this, but I meant to start the data import from Power BI Desktop, not app.powerbi.com.
Also note my post from 10 minutes earlier on getting the right URL.
Not the publish again =_= I don't want people to see what I put on my Google Spreadsheet =_=
are there any other way ?In case anyone needs this, here's a secure way to access Google Sheets.
https://tumbleroad.com/2016/07/07/free-marquee-google-sheets-template/
