Unable to take ownership of Dataflow

[judspud]

Hi,

We have a dataflow that was built by a user that is no longer in the business and their account has been deactivated.

When I try to select the ellipsis to access the settings of the Dataflow to 'take over' it just shows a spinning loading circle.

Any ideas?

Thanks

[Anonymous]

I was able to find a very simple work around for this exact issue! It looks like this is a UI problem and not an access problem. I was able to take over all the non-owned dataflows in our Dev, Test, and Prod workspaces using this method.

Here’s what I did:

1. First, find a dataflow that is not broken and go into the settings. Copy the settings URL and save it for reference: https://app.powerbi.com/groups/uniqueworkspaceID/settings/dataflows/owneddataflowID
2. Next, click on the non-working dataflow and copy the dataflow ID (all the letters and numbers after the last slash) from the URL
3. Last, replace the dataflow ID of the owned (working) dataflow with the non-owned dataflow ID https://app.powerbi.com/groups/uniqueworkspaceID/settings/dataflows/nonowneddataflowID
4. This will take you directly to the broken dataflow’s settings page and allow you to take over the dataflow
5. You will need to get the specific settings URL for each affected workspace and follow these steps

[ichavarria]

If you are unable to access the settings of the dataflow to take over the ownership, you can try the following steps:

1. Check if you have the required permissions to take over the ownership of the dataflow. You should have at least "Can edit" permissions on the workspace where the dataflow is located.
   
   

2. Try to delete and recreate the dataflow with the same name and schema. You can do this by going to the workspace where the dataflow is located, selecting the "Dataflows" tab, and then selecting the ellipsis for the dataflow and choosing "Delete". Once you have deleted the dataflow, you can recreate it with the same name and schema.
   
   

3. If you cannot delete the dataflow, you can try to export the dataflow and then import it into a new dataflow in a new workspace. To export the dataflow, go to the workspace where the dataflow is located, select the "Dataflows" tab, and then select the ellipsis for the dataflow and choose "Export". Once you have exported the dataflow, you can import it into a new dataflow in a new workspace by selecting the "Import" button on the "Dataflows" tab in the new workspace.
   
   

4. If none of the above steps work, you may need to contact Microsoft support for further assistance in taking over the ownership of the dataflow.

Best regards, 

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

[judspud]

Thanks for these suggestions. 

I am admin of the workspace so its not a permissions issue.

I cannot delete or export the dataflow as the drop down box with these options is whats not loading for me when I click the ellipsis.

I will contact Microsoft to see if they have a solution.

Thanks