Dataflow Refresh Failures

Same here, switched to dataflows last August to ingest CSV files from SharePoint to replace a massive PBIX with all queries inside, which took hours to refresh (and often failed).

When dataflows work it is much faster than our old solution and the dataflows usually refresh in 10-20 sec. But we also had to switch to another premium capacity in November, as our previous capacity was way overloaded and the dataflows were ver unrelaibale and refresh failed extremely often (>50%).

On the new capacity, the dataflow refresh failure is about 10-15% now, but at least the dataset refresh is doing very well >98% refresh success. What makes it worse is that there is no useful error message in the refresh history to indicate why dataflows fail. Every day something else is causing trouble, even if we have not touched any of the query code. Very unreliable user experience.

Also saving dataflows after editing is a pain, as there are all kind of error messages when trying to save a dataflow. Again, none of the save error helps to indicate what needs to be done to save sucessfully. 

So pathetic!

Definitely room for improvement for an otherwise compelling tool set.