Forum Discussion
Internal Dataflow Error on Power BI Dataset Refreh
Hi, sjrrkb123
I got similar feedback on this issue.
The cause of this issue is due to a known intermittent issue in Premium Gen2 workloads, including dataflows(ICM:297756751)
The issue is also listed in PowerBI Support forum.
https://powerbi.microsoft.com/en-us/support/
Known issue - Long running, failed or stuck dataflow in Premium Gen2
The current advice is to change the workspace to PRO and back to Premium if the problem keeps occurring.
It is recommended to look into reducing the number of entities within a single dataflow .
Best Regards,
Community Support Team _ Eason
Question for you, for the premium workspaces that you've downgraded to Pro and then assigned back to capacity, did this impact any dataflows with linked and/or computed entities?
- From my experience, this did not affect any linked/computed dataflows we use in this workspace. I cannot speak to what would happen if you have dataflows linked to these dataflows in other workspaces.
IOW, did downgrading lose some premium only settings?
- You will lose any premium only settings like incremental refresh or direct query dataflows. Again, due to our current data warehouse being full refresh, we are not using incremental dataflows. We do not currently have a use for direct query dataflows either. That said, both of these are listed as premium features so I would expect some interruption. I am not sure to what degree the effect will be.
What about incremental refresh settings? I believe when you downgrade, it drops the partitions and forces a full refresh. Then assigning back to capacity you would need to restablish incremental settings, correct?
- Again, we dont use incremental refresh so I am not much help.
For directquery to dataflows, do the reports using the dataflow stop working temporarily and then it's OK after putting back on capacity?
- To my knowledge, yes they would be interrupted but again we are not using direct query dataflows. Sorry 😞
I would suggest testing out the effect on these premium features in some down time for your organization.
I wish I could be of more help.
