Connection to data source fails

[Anonymous]

My data source is bigquery and so far scheduled refreshes have worked fine. Today however when trying to set up a scheduled refresh I get the following error:

'Failed to test the connection to your data source. Please retry your credentials.'

Retrying the credentials gives me following error message:

Failed to update data source credentials: ODBC: ERROR [HY000] [Microsoft][BigQuery] (8701) Error interacting with REST API: Timeout was reached ERROR [HY000] [Microsoft][BigQuery] (8701) Error interacting with REST API: Timeout was reached

Activity ID:	9aacf888-f871-4d90-b82c-e54d96c92795
Request ID:	8af0107e-86e1-ed83-8023-39490676a0e0
Status code:	400
Time:	Thu Jul 14 2022 15:08:18 GMT+0300 (Itä-Euroopan kesäaika)
Service version:	13.0.18620.44
Client version:	2207.1.12170-train
Cluster URI:	https://wabi-north-europe-k-primary-redirect.analysis.windows.net/

I have no idea what is causing this issue nor how to go about resolving it.

[v-luwang-msft]

Hi @Anonymous ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

Check that too many overlapping refreshes are scheduled.

And Scheduled refresh of large datasets can take a long time and be resource-intensive. It's important to not schedule too many overlapping refreshes since the maximum Model Refresh Parallelism in P2 is 12.

Please check the memory left and the refresh progress.

Refer  similar error code question:

Error interacting with REST API: Timeout was reached

REST api to google big query crashes

Connect to a Google BigQuery database in Power BI Desktop - Power BI | Microsoft Docs

Solved: Data Refresh Timeout Limit for P1, P2 and P3? Time... - Microsoft Power BI Community

Solved: Dataset Refresh Failing due to Timeout - Microsoft Power BI Community

How to configure workloads in Power BI Premium - Power BI | Microsoft Docs

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien