Starting overnight all my scheduled refreshes have been failing. Manual refreshes from the service also fail. I can refresh from the desktop app, and I can republish with no trouble. Seven datasets have failed so far. They all give the same error message in the refresh history: "Exception of type 'Microsoft.DataProxy.Exceptions.HybridException' was thrown." The only other thread I can find on here asking about that error message never came to any conclusion about what caused it. So that's...super helpful.
All of these datasets have previously successfully refreshed at least once since the last time I published them. Most of them were published months ago and refresh multiple times per day, so there's nothing new that should cause this. My gateway is online and visible from the service.
I see that there is a known issue in Nothern Europe causing refreshes to fail, but I am in the eastern United States, so either this is a different problem, or that problem is not limited to Europe.
Solved! Go to Solution.
I'm having the same problem. Non of the refresh options is working:
Power BI desktop: When I click "Refresh now", it seems to start refreshing but the process is immediatly stoped and the changes in my data is actually not refreshed
Power BI online, I get the following message:
Changed the "logon as" account of the "On-premises data gateway service" to "Local System". I restarted the service and restored the existing Gateway. Seems to be working fine. I still cannot figure out what the problem is, the gateway was running fine with the default "PBIEGWService" account.
My datasets all refreshed successfully once last night. I don't know if that means the problem has been entirely fixed, or if it's still going to be an intermittent problem.
Same here, in Northern Europe. The message is "DM_GWPipeline_Client_GatewayUnreachable".
Our on-premises gateway was accessible for the last few days. This is going on intermittently for about a week and it is causing a serious problem with users.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.