Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
hlad
Frequent Visitor

Taking over ownership of dataflow from someone who has left the organization

Hi,

 

We have couple dataflows which are failing to refresh. This is because the dataflows were owned by a colleague who has now left the organisation.

This is the error I get : "This dataflow can't be refreshed because it doesn't have a valid owner. {"RootActivityId":"908b5964-5b47-4348-88ee-0063f05ebbad"}"

 

Any suggestions on how i can take over the dataflows? At the moment when when i click on more options for the dataflow if does not give me any options. It shows as if its doing something, but nothing happens.

 

Any help will be appreciated. Thanks

 

Regards,

Hitesh

1 ACCEPTED SOLUTION
hlad
Frequent Visitor

Here is the workaround that was provided to me by a Microsoft Support Escalation Engineer which worked.       

 

This issue often appears when the original owner of the dataflow has left the organisation. The owner of the dataflow shows as blank and other users are not able  to take over the dataflow.
 
Using the Power BI UI, the only option is to restore the owner of the dataflow and then take over with other user.  If  this is not possible, the you can take over by using Postman.  This tool can be downloaded from https://app.getpostman.com/app/download/win64
 
Takeover Dataflow using postman

  1. Gather browser Traces (see steps below)
  2. Using Browser Trace, Get the folder ID and Request URL
  3. Using Browser Trace, get Access Token for your user account

 

hlad_0-1673204316219.png

 


 
 

  1. Get Dataflow ID from Power BI Service
  2. Use Postman send post request, URL will be as this example (replacing highlighted parts with the URL, dataflow ID and folder ID) https://wabi-south-east-asia-redirect.analysis.windows.net/metadata/dataflows/a420efd0-45e6-4235-8e3...

 

hlad_1-1673204316221.jpeg

 


 

  1. Enter Request Body as IsAllowNativeQueriesChecked = false

 

hlad_2-1673204316222.jpeg

 


 

  1. Add Authorization token

 

hlad_3-1673204316223.jpeg

 


 
 
 
Browser Traces

  1. Launch Google Chrome and navigate to the Power BI site.
  2. Click the button in the top right corner > More tools > Developer Tools 
  3. Select the Network tab in the dev tools console. Also enable "Preserve log" option as highlighted below:

 

hlad_4-1673204316223.jpeg

 


 

  1. Got to the workspace where dataflow resides and try to access the settings
  2. Once completed, right click anywhere in the left side first column in the trace window and select: "Save as HAR with content"
  3. Using application such as Fiddler we can open the browser Trace file. To download and Install Fiddler https://www.telerik.com/download/fiddler

View solution in original post

5 REPLIES 5
hlad
Frequent Visitor

Here is the workaround that was provided to me by a Microsoft Support Escalation Engineer which worked.       

 

This issue often appears when the original owner of the dataflow has left the organisation. The owner of the dataflow shows as blank and other users are not able  to take over the dataflow.
 
Using the Power BI UI, the only option is to restore the owner of the dataflow and then take over with other user.  If  this is not possible, the you can take over by using Postman.  This tool can be downloaded from https://app.getpostman.com/app/download/win64
 
Takeover Dataflow using postman

  1. Gather browser Traces (see steps below)
  2. Using Browser Trace, Get the folder ID and Request URL
  3. Using Browser Trace, get Access Token for your user account

 

hlad_0-1673204316219.png

 


 
 

  1. Get Dataflow ID from Power BI Service
  2. Use Postman send post request, URL will be as this example (replacing highlighted parts with the URL, dataflow ID and folder ID) https://wabi-south-east-asia-redirect.analysis.windows.net/metadata/dataflows/a420efd0-45e6-4235-8e3...

 

hlad_1-1673204316221.jpeg

 


 

  1. Enter Request Body as IsAllowNativeQueriesChecked = false

 

hlad_2-1673204316222.jpeg

 


 

  1. Add Authorization token

 

hlad_3-1673204316223.jpeg

 


 
 
 
Browser Traces

  1. Launch Google Chrome and navigate to the Power BI site.
  2. Click the button in the top right corner > More tools > Developer Tools 
  3. Select the Network tab in the dev tools console. Also enable "Preserve log" option as highlighted below:

 

hlad_4-1673204316223.jpeg

 


 

  1. Got to the workspace where dataflow resides and try to access the settings
  2. Once completed, right click anywhere in the left side first column in the trace window and select: "Save as HAR with content"
  3. Using application such as Fiddler we can open the browser Trace file. To download and Install Fiddler https://www.telerik.com/download/fiddler
lionx
Helper I
Helper I

@hlad have you gotten over this issue? 

hlad
Frequent Visitor

Yes I got the issue resolved.

NandanHegde
Solution Sage
Solution Sage

click on settings in dataflow:

NandanHegde_0-1671509699506.png

then click on take over:

NandanHegde_1-1671509731381.png

 

Unfortunately I cannot even get settings. When i click on the ellipsis I get this as if its opening, but it does not.

hlad_0-1671561423255.png

 

I have no issues with opening the settings for dataflows owned by me. The issue is only with ones that were owned by an ex employee.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors