All the Power BI models are failing to refresh

[Avivek]

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 1 Data 11/03/2024, 09:41:21 11/03/2024, 11:41:38 02:00:16.965 Failed (Show)

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.

[Anonymous]

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.

[Greg_Deckler]

@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".