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 step by step and the DSN connection actually worked, with each connection attempt google is requesting access to Googledrive as expected. 

 

But the issue seems to be with PowerBi as im getting error [HY000] when trying to connect, screenshot below. I didn't include my OAuth details in the photo but i have copied and pasted everything excatly as it should from the API.  Please help me with this issue. 

 

Best regards,

Murad. 

 

Need Help

5 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi Murad,

     

    In your scenario, as you want to get data from Google Sheets, I would suggest you follow  v-yuezhe-msft's suggestion to do it in this thread, instead of using third party driver. 

     

    Note: Do mask sensitive data before uploading.

     

    Best Regards,

    Qiuyun Yu

    • 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
        Community 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