Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Everyone,
All our power bi models are failing to refresh and it shows as timeout issue.
Data source error: | {"error":{"code":"DM_GWPipeline_Gateway_AdoNetProviderExecuteQueryTimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_AdoNetProviderExecuteQueryTimeoutError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: ********** | |||||||
Cluster URI: | WABI-US-EAST2-B-PRIMARY-redirect.analysis.windows.net | |||||||
Activity ID: | 069046da-6bd3-4e1f-9c05-09a72af499a5 | |||||||
Request ID: | f8ae229d-8ad2-43e6-8c8d-50109d10a255 | |||||||
Time: | 2024-03-11 06:11:38Z | |||||||
Details | # Type Start End Duration Status Error
|
All these models are showing timeout error, some have no date range and some are having some date range. yet all are failing with same error.
What are the troubleshooting steps for this issue? This is critical, I hope someone can help me on this.
Hi @Avivek ,
Based on your problems, here are my answers. It seems that the models are experiencing a timeout issue during the refresh process.
First of all, I think you need to make sure that the gateway is not overloaded with requests and the version of the gateway needs to be the latest version. This link you can update your gateway: Update an on-premises data gateway | Microsoft Learn
Secondly you can add timeout settings. For non-Premium workspaces, the limit is 2 hours, and for Premium workspaces, it's 5 hours.
Also you can consider using incremental refresh. You can read this document for a further study: Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn
Finally you can also examine the refresh history in Power BI to determine the pattern or specific table that caused the timeout problem: Data refresh in Power BI - Power BI | Microsoft Learn
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Avivek Looks like either a problem with your gateway, some ADO.NET provider. What source are you using? Maybe you need to upgrade the gateway? I would do that first and then if you are still having issues contact support.
You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
109 | |
88 | |
76 | |
66 |
User | Count |
---|---|
126 | |
112 | |
99 | |
82 | |
73 |