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
Feedback sent
We appreciate your effort and will try to fix the article