Forum Discussion
REST api to google big query crashes
This error occurs 7 out of 10 refresh runs:
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 Table:
If it stops, it occurs on different tables, so it's not the connection, permission or query.
Anyone an idea?
we think it was related to having multiple refreshes on the same tables in GBQ at the same time. Since we have organised the refreshes to not run simultaneously it didn't happen anymore
10 Replies
we think it was related to having multiple refreshes on the same tables in GBQ at the same time. Since we have organised the refreshes to not run simultaneously it didn't happen anymore
Hey Johan,
I'm not sure I understand your explanation. You say you spread out the "refreshes" on your table in BQ. Do you mean the refreshes triggered by the powerBI service? I don't know of a way to control when particular data is being refreshed. For me the whole file just refreshes at once. Can you explain a little how you managed to do this?
My situation is that powerBI is refreshing 8 views on the same table, and I wonder if that is similar to your situation.
Thanks!
Jaap
Sure I can give more details.
We were loading the same report (prod and test) at the same time it appeared. So 2 refreshes loading the same tables/views. After stop doing that, the problem did not occur anymore.
Hope this helps.
Johan
Hi Johan
Sorry, I can't reproduce your issue, please kindly raise it to support team for better advice. thanks!
https://powerbi.microsoft.com/en-us/support/
