Forum Discussion
How to Connect Google Sheets to Power BI without changing Privacy Settings or publishing data online
Super Userzacbisenio , As far as I know, min setting share anyone with link
I used same here in the power bi part
Hi amitchandak ! I tried using the same format: https://docs.google.com/spreadsheets/d/<ID>/export?format=xlsx&id=<ID>. The result is "We didn't find any tables on this page". When I tried using a browser, apparently this link is asking me to download the file. What should I do?
Hi zacbisenio ,
Please try the method in the following links and check whether you can connect to Google sheet in Power BI Desktop successfully:
1. Add the part "export?format=xlsx&id=" where the edit/? had previously started
How to connect google sheet to Power BI (Check the message 12 from GGetty)
How to connect google sheet with power bi?
2. Use custom connector
Custom Connector to import Google Sheets with OAuth2 authentication in PowerBI
Google Spreadsheets Connector for Microsoft Power BI
3. Connect to Google Sheets as an ODBC Data Source
Author and Share Power BI Reports on Real-Time Google Sheets Data
4. Use R
How to use Google Sheets as an online database for your BI project
Best Regards