Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 you...
Need Help
v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

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 Regards

Lucien