Dataflow does not stop refreshing running for 10 hours

[Samurize24]

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

[Samurize24 · Accepted solution]

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

[Anonymous]

Hi@Samurize24,

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 Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Samurize24]

Hi,

We did already tried that with no succes. There is a transaction 'active' that keeps on running. 

Kind Regards,

[Anonymous]

Hi@Samurize24,

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 Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Samurize24]

Hi Caitlyn,

In total we had like 7 issues, the reset op the workspace helpt reducing it to 3.
-We are on premium.
-The data is not connected true a gateway.

-We changed the source. ( even a blank query, with source= "test")
-We can edit, but not save changes to the query.
-We have reset the workspace.

Kind regards,
Prashand