Forum Discussion
ODBC: ERROR [HY000] [Microsoft][DriverOAuthSupport] (8701) Error interacting with REST API
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?
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).