Forum Discussion
Solved
Connecting to a Google spreadsheet
Hi
I am unable to connect powerBI to a Google spreadsheet. I am assuming this is due to access restrictions. I created this sheet using my work email account. How do I open the access and connect it to PBI?
Please suggest. Thanks
I am unable to connect powerBI to a Google spreadsheet. I am assuming this is due to access restrictions. I created this sheet using my work email account. How do I open the access and connect it to PBI?
Please suggest. Thanks
Hi abhitiwa,
To connect to Google Spreadsheet, you can go to that specific spreadsheet, use Publish to the Web, change the selection from Web Page to Microsoft Excel. Copy that generated URL, go to Power BI desktop, use Web data source and paste URL, enter credential use Basic Authentication to get data.
Best Regards,
Qiuyun Yu
1 Reply
Hi abhitiwa,
To connect to Google Spreadsheet, you can go to that specific spreadsheet, use Publish to the Web, change the selection from Web Page to Microsoft Excel. Copy that generated URL, go to Power BI desktop, use Web data source and paste URL, enter credential use Basic Authentication to get data.
Best Regards,
Qiuyun Yu