Anonymous's avatar
Anonymous
Not applicable
3 years ago
Status:
Done

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

Gateways
Report Server

4 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous 

     

    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's avatar
    brooksie1821
    Regular Visitor
    3 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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

     

Completed Ideas