Connecting to a Google spreadsheet

[abhitiwa]

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

[v-qiuyu-msft · Accepted solution]

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