Random Dataset Refresh Failures after Oct 2024 Gateway Upgrade

[BobLang]

Our BI On Premise Gateways are located on 3 different servers and clustered into a single gateway cluster.  I recently upgraded the gateways to the October release.  I initiall installed verson 3000.242.5 on Oct 18th and then installed version 3000.242.9 a couple of days ago.

Since installing the October versions, we have had random refresh failures with the following error message:

{"error":{"code":"DM_GWPipeline_Gateway_DataSourceAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_DataSourceAccessError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: XXX

If we resteart the refresh, it completes with no issues.  If the dataset fails again, it is on a different table.

Any suggestions on how to resolve this issue besides rolling back to an older version of the gateway?

Thanks,

Bob L.

[zbi]

We have updated to the 3000.242.9 version last week in our company and users experience same refresh behaviour - refresh fails randomly, next time scheduled refresh or ad-hoc refresh finishes ok...

[Anonymous]

Hi @BobLang ,
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered? If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

[SaiTejaTalasila]

Hi @BobLang ,

Even one of our gateway have the same issue. For now we have created the connections under different gateway.

If you want to rollback to older versions you can refer this thread.

https://community.fabric.microsoft.com/t5/Service/Power-BI-Gateway-Server-April-release-bug-how-to-r...

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-monthly-updates

I hope it will be helpful.

Thanks,

Sai Teja