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
but I don´t want to publish, as my data is and must remain private.
I understand that the whole world will have access to my data at the moment I click on publish button... am I right?
I think I need to use google API to restrict access to my sheets, if yes, how can I use google API to make Power BI read my sheets?
if no, how can I make Power BI read my restricted sheets?
you have the some question as I am, I don't want to publish my google sheet so i'm asking are there other solutions for this ?
