Forum Discussion
Advocate VData Refresh Errors after Enterprise Gateway upgrade
Advocate IVDid you ever get more information or resolution? I am seeing the same issue.
I haven't checked on the config for trusted servers, but that seems like it would be an all-or-nothing proposition and it would never work instead of random, sporadic errors.
Thank you!
Advocate VI was given a bandaid. There's a config file for the gateway...same one where you update the Trusted Servers. One of the flags in the file is "NextResultSkipped." They had me flip that to True. It killed the refresh errors, allowing the reports to refresh. I've not been able to get them to explain exactly what that does, but CoPilot says it basically tells the refresh not to get data it doesn't need to refresh the report--but I have no idea how the engine determines that. The tech support folks really really wanted me to close the ticket before the end of the year with the promise that they'd reach out to me after the 3rd week of the new year--but I have yet to hear from them and have been too busy to reach out. The whole process this time has been less than satisfactory. I actually sent a request to have the ticket escalated and while that may have happened, they've forced me to continue working with someone I have a very hard time communicating with.
Ping me if you want to know more about the band aid and I can tell you exactly what to do.
Hi motoray , are you still using the bandaid till now? We're past 6 months of frustration as well.
After working extensively with Microsoft, was determined SQL connection was hanging causing the timeout error. To resolve:
Go to:C:\Program Files\On-premises data gateway\Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config
Change <value> setting
<setting name="NextResultSkipped" serializeAs="String">
<value>True</value>
</setting>
Since making this change we haven't had any additional errors for this. This solution is not documented anywhere.- motoray
That's the exact same one they had me implement. After each gateway upgrade, they'd have me flip the switch back to False and we'd watch for failures. When the failures came back (as they have since the Jan. 2025 update), we'd go back and flip the switch back.
JohnJ2, did they ever explain what that switch actually does and how? I never got a good answer from Microsoft. CoPilot said something about it telling the Gateway to only load stuff it needs to refresh, but that left me with more questions than answers. When I asked the question of Microsoft, the best answer they could provide was something like, "when you change that value to true, your errors go away."
