Forum Discussion
Google spreadsheet integration
Hi mconcli,
Based on your description, it seems that you follow the guide in this tutorial to connect to Google Spreadsheet in Power BI Desktop. I test this process, and I only get a "Key" and "Column Heading" column with none of my sheets data. What is the result in your scenario? I would recommend you contact trebgatte for further help.
And as far as I know, there are no official articles or other blogs stating that using Google's API to connect to Google Spreadsheet. An idea about connecting to Google sheets in Power BI has been submitted in this link, please vote it up.
Currently, you can connect to files on Google Spreadsheet from Power BI Desktop via Get Data->Web entry. Assume that you connect to a Excel file, open it in Google Spreadsheet, go to File / Publish to Web, then change the selection from Web Page to Microsoft Excel. Copy the generated link and input the URL in Get Data->Web Window of Power BI Desktop, then enter your Google account and Password. For more details, please review the following screenshots.
Thanks,
Lydia Zhang
Hi mconcli,
Based on your description, it seems that you follow the guide in this tutorial to connect to Google Spreadsheet in Power BI Desktop. I test this process, and I only get a "Key" and "Column Heading" column with none of my sheets data. What is the result in your scenario? I would recommend you contact trebgatte for further help.
And as far as I know, there are no official articles or other blogs stating that using Google's API to connect to Google Spreadsheet. An idea about connecting to Google sheets in Power BI has been submitted in this link, please vote it up.
Currently, you can connect to files on Google Spreadsheet from Power BI Desktop via Get Data->Web entry. Assume that you connect to a Excel file, open it in Google Spreadsheet, go to File / Publish to Web, then change the selection from Web Page to Microsoft Excel. Copy the generated link and input the URL in Get Data->Web Window of Power BI Desktop, then enter your Google account and Password. For more details, please review the following screenshots.
Thanks,
Lydia Zhang
Hi Anonymous I am following the instruction (while publishing to Web option "Require viewers to sign in with their [Company] account" was checked if that changes anything - I don't want this source to be widely available) and I get stuck cause I get invalid credentials account. What am I doing wrong? I am using my google login and pass that are correct (I retried several times and checked by simply logging in via Google Docs - it works).
I tested a lot, and I am sorry to tell you: the only way to make PBI read data from Google Sheets is when you publish to the web as a public document, where anyone can see the data.
credentials for google sheets does not work on PBI, and there is nothing planned in the near future...
this idea below is under review for more than 2 years! why is it taking so long?
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6656584-connectivity-to-google-sheetsI'm guessing Microsoft wants people to use Office Online instead (which integrates fine with Power BI).
I bet someone will find a workaround before an official integration with Google Spreadsheets is released. All we need is a service that is able to get data from a (private) google spreadsheet and throw it in a (private) Excel Online document. I tried to get Excel to do it directly, but got the same credential issue - therefore the need for an intermediate service.
