Forum Discussion
Connection to data source fails
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.
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:
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 RegardsLucien
2 Replies
- v-luwang-msftCommunity Support
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:
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 RegardsLucien
- v-luwang-msftCommunity Support
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