Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Dataset refresh fail {"error":{"code":"DM_GWPipeline_Client_AsyncOperationStreamingRetriesExhausted

Hi,

Need help with this error please.

 

This error appeared in power bi service after having started a refresh with a local gateway (localhost), usually it works without issue, but today there is this error? any idea where it comes from please?

 

My gateway is up to date.

 

Erreur de source de données: {"error":{"code":"DM_GWPipeline_Client_AsyncOperationStreamingRetriesExhausted","pbi.error":{"code":"DM_GWPipeline_Client_AsyncOperationStreamingRetriesExhausted","parameters":{},"details":[],"exceptionCulprit":1}}}
URI du cluster: WABI-FRANCE-CENTRAL-A-PRIMARY-redirect.analysis.windows.net
ID d'activité: 4085821c-8a6f-4dfa-909e-ccc7177ad6ad
ID de demande: f44e4d38-ddcf-2c8b-5872-a6bf0e92023e
Heure: 2023-03-17 13:56:22Z

Status: Delivered

Hi all,

 

Our colleagues gave feedback on this issue on the internal platform, and after investigating the error codes provided, the product team came to the following conclusion:

"In general this is an issue with the data sources itself but not an issue with Power BI or gateway. Most of the times data source is slow in responding which is why open connection requests fail causing the refresh to fail."

 

Best regards.
Community Support Team_ Caitlyn

 

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi @cher90 ,

 

If you want to get better help, in addition to the error code, we would like you to provide a detailed error message for this problem, which is usually a summary sentence.

 

Best regards.
Community Support Team_ Caitlyn

cher90
Helper II

Hi @v-xiaoyan-msft 

 

Thanks you feedback!

 

This error appeared during a refresh with the local gateway and my local postgres database. 

 

When i refresh from power bi service i meet a crash, and when refreshing the partitions manually with SSMS it works fine.

 

Amine

 

brooksie1821
Regular Visitor

Has there been any progress on this one?  We are seeing the same issue when trying to hit a multi source dataset that uses incremental refresh.  The dataset lives in a premium workspace and stopped working on the 03/18/2022.  Can provide additional information if needed.

 

Full Error:

 

Data source error: {"error":{"code":"DM_GWPipeline_Client_AsyncOperationStreamingRetriesExhausted","pbi.error":{"code":"DM_GWPipeline_Client_AsyncOperationStreamingRetriesExhausted","parameters":{},"details":[],"exceptionCulprit":1}}}
Cluster URI: WABI-US-EAST2-C-PRIMARY-redirect.analysis.windows.net
Activity ID: 2a7e6dbe-fbd6-46b6-ad2b-5a145164b374
Request ID: d074978d-cdaa-bffa-4015-11bc9ae44195
Time: 2023-03-22 15:25:39Z

v-xiaoyan-msft
Community Support
Status changed to: Delivered

Hi all,

 

Our colleagues gave feedback on this issue on the internal platform, and after investigating the error codes provided, the product team came to the following conclusion:

"In general this is an issue with the data sources itself but not an issue with Power BI or gateway. Most of the times data source is slow in responding which is why open connection requests fail causing the refresh to fail."

 

Best regards.
Community Support Team_ Caitlyn