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,
Tried using this, however after building connection it doesnt load the file properly. With other methods too, constant error is this the table view has 4 columns (not part of usual data base). Even after i move ahead from preview, the actual data doesnt load
I've used this custom connector recently and it worked just fine:
https://www.thebiccountant.com/2017/09/24/custom-connector-import-google-sheets-oauth2-powerbi/
Should this be working as well with Power BI Report Server?
Best Regards
Hi Anonymous ,
you can publish the report also on the report server, but you cannot schedule a refresh unfortunately, due to current limitations with OAuth: https://docs.microsoft.com/en-us/power-bi/report-server/scheduled-refresh
hey thanks, can we connect
ImkeF wrote:I've used this custom connector recently and it worked just fine:
https://www.thebiccountant.com/2017/09/24/custom-connector-import-google-sheets-oauth2-powerbi/
google sheets linked to company id with power bi?Hi PowerBI_AB ,
I don't understand what you mean with "linked to company id " (I'm not very familiar with GoogleSheets actually)