Forum Discussion
Unable to Delete DataFlow
I am unable to delete 2 dataflows because it says it has a linked table. However, both dataflows are empty (no queries and no tables) as I had removed everything from them and there is no other items in my workspace. Yet, it still is unable to be deleted. Any help would be appreciated. I even tried doing it through the PowerBI REST API but continue to get the same message
The message it keeps giving me is "This dataflow can't be deleted because linked tables in this workspace are dependent on it. Please remove any linked tables from dependent dataflows and try again."
7 Replies
This is a known Power BI service issue. The dataflows look empty, but Power BI still has hidden linked-table metadata, so it thinks there are dependencies.
Why it happens:
Linked table metadata is not fully removed
Even with no queries or tables, the dependency remains
REST API shows the same error because it uses the same backend check
Things to try:
Open each dataflow
Add a dummy query
Save
Delete the dummy query
Save again
Wait a few minutes and try deleting
Ask a workspace admin to confirm:
No other dataflows exist
No semantic models are linked
Recreate and unlink:
Create a new dataflow
Link it to the problematic one
Save
Remove the linked table properly
Save
Then delete both
If none works:
Open a Microsoft support ticket
Ask for backend cleanup of orphaned linked-table metadata
Mention the issue happens in UI and REST API
Sounds good, since i have git integration I am just trashing that workspace and basically making a new one and mirrioring the git to it so should work just interesting.
Hi EricQuan ,
In order to make the further troubleshooting and give you a solution shortly, could you please provide the following info?
- Are you trying to delete the dataflow in Power BI Service?
- Are you the owner of the workspace where the dataflows are located?
- According to the error message, it seems that there are some other objects are dependent on it. If there are any reports, dashboards, or other dataflows in your workspace that are dependent on the dataflows you’re trying to delete, you’ll need to remove these dependencies first. Data lineage - Power BI | Microsoft Learn
Best Regards
Anonymous
1) Yes I am trying to delete the data flow from the workspace in the Power BI Service
2) Yes I am the owner of the workspace
3) There doesn't seem to be any other dependencies at all. The lineage views show nothing other than the 2 data flows and they are not connected to eachother
I have the same problem, nothing is linked but I'm getting this error message when trying to delete the DataFlow.
Hello Anonymous
I have the Same problem too.
Hi EricQuan ,
Please let me know if you found any solution for this, bcz i have 2 dataflows which are giving error same as yours and they are empty too.
Thanks
