Connecting Power BI to Private Google Sheet

[tylerbauer]

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?

[v-yuezhe-msft · Accepted 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,