Forum Discussion

lalkiran's avatar
lalkiran
New Member
7 years ago

ODBC: ERROR [HY000] [Microsoft][DriverOAuthSupport] (8701) Error interacting with REST API

Hi,

 

I am accessing Google BigQuery API through Power BI Desktop and I am getting below error:

 

ODBC: ERROR [HY000] [Microsoft][DriverOAuthSupport] (8701) Error interacting with REST API

 

Details: "ODBC: ERROR [HY000] [Microsoft][DriverOAuthSupport] (8701) Error interacting with REST API: Couldn't connect to server
ERROR [HY000] [Microsoft][DriverOAuthSupport] (8701) Error interacting with REST API: Couldn't connect to server"

 

Any idea what it is and how to resolve this? 

This shouldn't be access related as I am able to access BigQuery from Web UI.

 

Thanks,

Lal

Need Help

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI lalkiran ,

    Can you please share more detail information to help us clarify your scenario? In addition, you can also use fiddler to trace connection operation to find out which type of request failed or blocked. 

    Regards,

    Xiaoxin Sheng

    • lalkiran's avatar
      lalkiran
      New Member
      7 years ago

      Hi,

       

      Anonymous 

       

      I have Firebase data hosted on Google BigQuery (sandbox). I want to access that data through Power BI for my reporting purpose. When I am trying to do this using 'Google BigQuery' API (available in Power BI). I have got this error:

      Error Screenshot

       

       

       

       

       

       

       

       

       

      I would like to know what is causing this error? I have used the Admin creds for this.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi,

         

        We are having the same issue.

         

        Is there any more info on this?


        Best,


        Ali A

  • AlexanderBrueck's avatar
    AlexanderBrueck
    Regular Visitor
    6 years ago

    Same issue here - for the last 4-6 weeks reports randomly fail to refresh with error message "ODBC: ERROR [HY000] [Microsoft][DriverOAuthSupport] (8701) Error interacting with REST API: Couldn't connect to server ERROR"

     

    The only solution found yet is to refresh reports in the desktop app and upload it again.

     

    Anyone has idea how to tackle this problem?

    • ju_jacobowiski's avatar
      ju_jacobowiski
      Frequent Visitor
      6 years ago

      AlexanderBrueck , 

      That's how I sorted it:

      1) Load BigQuery data into PowerBI dataflows, using it as a 'mini' data source.
      2) Add the billing-id in the source step (at PowerBi dataflows)

      Once it's done, I schedule a refresh between the Dataflows and Google BigQuery, which works just fine. Then I have to change in PowerBI desktop the source of the dataset (from BigQuery to PowerBI Dataflows).

      Back to service, I set up the refresh of the dataset to sometime after the refresh of the dataflows is done (I let 2 hours of difference). So far is working fine.

      Worth mentioning that Microsoft got in touch with me saying the problem is with BigQuery. But Google BigQuery says the problem is not on their end either - especially because it's possible to update the data through PowerBI Desktop. I hope the solution above help this out.

      I did it 2 months ago and so far the schedule refresh worked 99% (only 1 day it didn't refresh).