Forum Discussion
Dataflow does not stop refreshing running for 10 hours
I have a issue with our workspace.
Due to our own fault, a dataflow can't refresh. The issue is that it is 'stuck' and we can't stop de refresh. it keeps running en we can even start a new refresh action.
Even if we cancel, it keeps running. We ask the admin to reset/ reboot the workspace but no suscces.
The dataflows are connected trough linked entities, but we removed the linkend in hope we could cancel the dataflows then.
We can't even delete the flows, because it is refreshing. So we are stuck in a loop you could say.
Any advice woul be much appreciated.
dataflow refresh bug error
Hi All,
Finally its's resolved. I used the API to remove the dataflow.
https://learn.microsoft.com/en-us/rest/api/power-bi/dataflows/delete-dataflow
5 Replies
- AnonymousNot applicable
HiSamurize24,
Sometimes dataflow refresh takes a long time, sometimes too long. Now with the new “Cancel refresh” control you can cancel the refresh when you need to, whether it’s for editing dataflows queries or any other reason.
The “Cancel refresh” action is available in the Dataflows page “Actions” menu.
Note: In workspaces that are not assigned to premium capacity, dataflow refresh may not be immediate. Dataflow refresh will stop only after completing the current entity refresh.
For more information,you can refer to this :Power-bi-Dataflows-General-Availability
Hope it helps.
Best Regards,
Caitlyn YanIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
- Samurize24Frequent Visitor
Hi,
We did already tried that with no succes. There is a transaction 'active' that keeps on running.
Kind Regards,
- AnonymousNot applicable
HiSamurize24,
If you are using the on-premise data gateway for the connection, then you can restart the gateway service, which will kill the connection. Or please try to disconnect from the data source.
Hope it helps.
Best Regards,
Caitlyn YanIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
- Samurize24Frequent Visitor
Hi All,
Finally its's resolved. I used the API to remove the dataflow.
https://learn.microsoft.com/en-us/rest/api/power-bi/dataflows/delete-dataflow