Today I could refresh three dataflows in one workspace without an error (although one dataflow needed a retry). But I could not refresh three other dataflows with exactly the same entities and the same queries in another workspace . Sadly, the latter workspace is our production environment, so we are in trouble right now.
Whenever I saved changes after an edit, even if I did not change anything, the dataflow might or might not refresh. Sometimes it fails with an 'Internal Error', sometimes with a 2 hour time limit exceeded after 10 minutes? Sometimes editing and saving without changes fixes the issue, sometimes refreshing under another account. But now none of these actions changes the behaviour of the dataflows; they will not refresh anymore. Even worse, from our point of view there does not seem to be any logic behind the occurences or absence of refresh failures.
We switched to dataflows because they should be past the preview phase by now, and they seemed a good solution. We develop our queries in Power BI Desktop, to minimise the number of changes on the actual dataflows. Hence it is still possible to replace all dataflows with the queries from this file using the original data sources. But that requires a lot of rework on all the datasets behind the (already published) reports.
Has anyone simular experiences with dataflows? Does anybody know a remedy for this eractic hebaviour?