Forum Discussion
Gateway Issue
A mind-blowing 24 hours.
The issue resolved on it's own 24 hours later, Microsoft rep could not come up with a cause.
I had a copy of the Dataflow running in a different Workspace in the same Capacity, 0 issues over the 24 hours, while the original continued to perform terribly (as much as 5 hours longer to refresh).
This led us to believe it was literally the Workspace itself with an issue, yet nothing about that Workspace changed or differed from the others. No idea.
Mine was a small set of dataflows with no actual models! Afraid I couldn't comment on implications without knowing data volumes and any incremental load setups.
Just to be clear the fix that worked for me might be completely unrelated. I wondered if my issue was something to do with the enhanced compute engine.
You could try turning it off on just that dataflow and back on?
As said, no firm envidence but it might help and is safer than changing something at workspace level.
Tried both the Premium to Pro to Premium and the Engine with no luck.
What does work is rebuilding the Dataflow in a different Premium Workspace.
Datasets in the Workspace with issues seem to work, Dataflows do not.
Okay, well it seems to now have started working. I don't know why, all other Workspaces worked fine during this period, even those with Dataflows hitting the same source. That leaves me thinking there was a 4-5 hour issue with this particular Workspace if that is even possible!
Weird morning
It's back to going in the wronggg direction, each refresh is longer than the last. Something is very strange. I've opened a Ticket and will report back if I learn anything.