Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I am trying to connect Power BI Desktop to a private google sheet. For security reasons, we can't make the google sheet public. I tried to authenticate my credentials but it isn't working. Any ideas?
Solved! Go to Solution.
@tylerbauer,
There is no built-in connector for Google sheet in Power BI Desktop, an idea about this issue has been submitted in the link, please vote it up.
As you can't make the google sheet public and are unable to connect to it via Web entry in Power BI Desktop, you can consider to create a DSN for your google sheet, then connect to google sheet as an ODBC data source in Power BI Desktop, for more details, please review this blog: https://www.cdata.com/kb/tech/gsheets-odbc-power-bi.rst .
Regards,
@tylerbauer,
There is no built-in connector for Google sheet in Power BI Desktop, an idea about this issue has been submitted in the link, please vote it up.
As you can't make the google sheet public and are unable to connect to it via Web entry in Power BI Desktop, you can consider to create a DSN for your google sheet, then connect to google sheet as an ODBC data source in Power BI Desktop, for more details, please review this blog: https://www.cdata.com/kb/tech/gsheets-odbc-power-bi.rst .
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.