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

Hi v-qiuyu-msft

 

Its taking longer to fetch back the error so I think we closer than ever on this.

I'm getting a Successful DSN connection message but the same error on PowerBi, CDATA has the same version you do but my PowerBi's version is 2.52.4921.461. I can see that you can access multiple sheets, to double check, did you only enter the OAuth details when establishing CDATA's connection? Would be great if you could tell me how you established your connection, I'm afraid i might have skipped a step during the configuration. 

 

Best regards,

Murad.

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

Hi Murad,

 

When I create a DSN in ODBC, I just provide the OAuth Client Id and OAuth Client Secret information, then Test Connection. As long as the connection is successful, you should be able to get data in Power BI desktop follow steps in my previous post.

 

Best Regards,
Qiuyun Yu