Forum Discussion

Murad's avatar
Murad
Frequent Visitor
8 years ago

Connecting to GoogleSheets Via ODBC/CDATA

Hello,    I'm trying to connect one of my protected googlesheets into powerBi. I thought that this can't be done unless if the sheet is public but then I came upon this. I followed the guidance ste...
Need Help
Murad's avatar
Murad
Frequent Visitor
8 years ago

Thanks v-qiuyu-msft but the issue with that approach is that i have to publish my data and make it public to the web. I want to keep my personal data where it is without publishing it. 

 

Best regards,

Murad. 

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Murad,

 

Based on my test about CData ODBC driver for Google Sheets, from Power BI desktop, it can get data from ODBC fine. 

 

In your scenario, please make sure the DSN has correct credential and Test Connection to check if it's successful. 

 

 

When you get data in Power BI desktop, please use Default or Custom type to connect. 

 

 

Also please try to update Power BI desktop and driver to the same version as ours. 

 

 

 

Best Regards,
Qiuyun Yu