Forum Discussion
Google spreadsheet integration
I'm sorry for repeating this issue, but even looking at the TumbleRoad tutorial I wasn't able to do what I wanted.
I need to take my data from Google spreadsheets into PowerBI via API (in order to get data automatically), is it possible? Could someone post a tutorial?
Thank you.
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
13 Replies
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 ZhangLydia,
Are sure you're able to access a google sheet that has Access Restrictions? I find that i must give open world access to the sheet in order to access it via Power BI. Can you confirm that you're still able to use the method you describe above? What type of google account are you using? Any further information is greatly appreciated.
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 ?
Hello Mconcli
I also suffered this type of problem when I found a blog which solved my all issues. so go through the SSIS Facebook API hope it also works for you.
