Data Refresh Errors after Enterprise Gateway upgrade

Long story short after our own support ticket: There is no other option than to change the setting on the gateway as described. I can confirm refreshes no longer fail.

They said that if changing this setting has positive results, it means the underlying cause is a network delay in critical operations. This setting skips the processing of sensitivity label metadata, which is a time-critical operation causing a failure for the wider refresh. Most queries don't have an associated label. An update in the future will include changes to be more resilient with such network latency issues and remove this setting.

Our understanding (accurate or not) is that the (SQL) connection hangs for whatever reason and switching that setting forces it to drop ... or some such thing. We focused on one report that was erroring and it happened to be using an SQL connection otherwise it was chasing ghosts.

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."

Thanks for that explanation JohnJ2 -- it's more than I got from anyone else. All of our failures have been with on-prem SQL connections through the gateway. 

Just did another call with a different Microsoft tech and passed off more dataset and request IDs and log files for them to look at.

Any update for you guys? motoray 

I've been out of the office a while, so a colleague has been keeping this going with Microsoft. We were bascially told that they were going to change the configuration to default to True in the config file going forward, but there were no other details beyond that. This has been a most unsatisfatory support experience. Everything worked fine up until about July of last year and then it's been failures since.