Forum Discussion

motoray's avatar
motoray
Icon for Advocate V rankAdvocate V
1 year ago

Data Refresh Errors after Enterprise Gateway upgrade

After upgrading to the October 2024 gateway, I'm getting refresh errors randomly for scheduled Power BI refreshes. The error is: "DM_GWPipeline_Gateway_DataSourceAccessError","pbi.error":{"code":"DM_...
Dataflow
kymramosrpo's avatar
kymramosrpo
Icon for Advocate V rankAdvocate V
1 year ago

have been experiencing the exact same issue here for weeks. Error logs are of no help at all. Have you found a solution, or even a way to diagnose the problem?

motoray's avatar
motoray
Icon for Advocate V rankAdvocate V
1 year ago

We were given a solution that's worked well enough for us with the promise of Microsoft doing some kind of more permanent fix in a future gateway.

 

There's a configuration file--Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config. On our servers, it's here "C:\Program Files\On-premises data gateway." 

 

Open the config file in a text editor and scroll down to almost the bottom. Find the "NextResultSkipped" setting and change the value from False to True. After that, restart your gateway and see if the failures stop. They did for us. I never got a satisfactory answer about why they stopped.

  • kymramosrpo's avatar
    kymramosrpo
    Icon for Advocate V rankAdvocate V
    1 year ago

    Thanks for sharing! I've set it up just now. Hope to see some improvements soon. Will share the results here!

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Was it more stable, kymramosrpo ? We did this today as well.

      • kymramosrpo's avatar
        kymramosrpo
        Icon for Advocate V rankAdvocate V
        1 year ago

        Hi Anonymous - yes! Dataflows are now stable. Thank you!