Power BI - work-around for Changing 'Ownership'

Created by Erik Åkerlund, Modified on Thu, 25 May 2023 at 08:44 AM by Elin Stenrud

If one person creates the report (and therefore 'Owns' the report) it is not possible for anyone else to change the selections in the report in the dataset in Power BI. Other person can change the selections in TS - but the same will NOT be reflected in the graphs that is presented in TS/Power BI as the output.

Here is a work-around how to do it;

The person that wants to take over ownership of a database and dataset needs to do the following:

  • Copy the relevant report in TS
  • Rename the original report in TS (add “_org” for example)
  • Rename the copy to match the original name of the original report
  • Run the new report in TS to create the PowerBI dataset
  • Open reports linked to the dataset in PowerBI Desktop
  • Change the data source to the new dataset created in PowerBI

To change the data source, in current version in Power BI Desktop;

  • Publish the report to PowerBI

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article