Refresh Fails Big Query REST API Timeout

[RX00]

Hi PBI Community, 

We're having some serious issues with Dataflow refreshes. We currently use Google BigQuery as our source and PBI dataflow to ingest the data. 8 out of 10 times, the refreshes go off without a hitch. The dataflow then encounters a problem and fails to ingest new data. It keeps saying that the REST API: Timeout has been reached. However, once you manually refresh the data in the PBI workspace, the Dataflow resumes operation.

Error: Data Source Error : DataSource.Error: ODBC: ERROR [HY000] [Microsoft][BigQuery] (8701) Error interacting with REST API: Timeout was reached

Connection settings:

We currently use Power BI Premium per user and make sure to schedule refreshes one at a time to avoid refresh parallelism. We also discovered that when you turn off incremental refreshes and then turn them back on, Dataflow resumes working. Any advice on this matter would be greatly appreciated.

[v-rongtiep-msft]

Hi @RX00 ，

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-rongtiep-msft]

Hi @RX00 ,

For this type of error, you can refer to the solution in last post, see

https://community.powerbi.com/t5/Service/Error-interacting-with-REST-API-Timeout-was-reached/m-p/171...

https://community.powerbi.com/t5/Service/REST-api-to-google-big-query-crashes/m-p/800366

if you still have problem, please let me know.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi @RX00 

It sounds like there could be connectivity issues from time to time when this happens?

[RX00]

Could you elaborate further? You might be on to something.