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

[cher90]

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

[v-xiaoyan-msft]

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]

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]

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]

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