Forum Discussion
Change datasource for a dashboard
Hello,
We have a group in powerbi.com with some dashboards and reports. We also use powerbi desktop.
In this case, we have a procedure to refresh de report data from desktop version and then publish in powerbi.com. With that procedure, a person could update powerbi.com report and the dashboard will be also updated.
but... now we have a problem. The person who did that procedure is not available. Someone new do the same procedure but when that person publish the report, powerbi.com create a new report. It is because the owner are different persons. With this problem, we cannot refresh the dashboard...
what we should do?
- There is any chance to change the owner?
- There is any chance to change the datasource for this report?
serargi Yes. If this is shared with the workspace then it technically isn't owned by the workspace. It is owned in the Personal workspace. If it was originally published directly to the group workspace it would just automatically update.
If you are sharing content with a wider audience, it is recommended that it never originate in your personal workspace. I would publish the new one, rebuild the dashboard and share it with the same end users and remove the old one.
5 Replies
serargi This sounds like a workspace issue, not a datasource issue. If you published the PBIX file to an App Workspace (group workspace) then it wouldn't matter who published the report, if it had the same name, then it would overwrite what was in the Service. In addition, this is what gateways are for, so you can schedule automated refreshes...
I would recommend the following:
First, create the shared workspace so you don't have this issue. Set up a gateway to schedule refreshes. Add multiple users to the workspace so no one person owns something and you run into this issue again.
Hello Anonymous
I did it again, but I have the same problem. After publish from desktop version, powerbi.com create another report and doesn't overwrite the original one.
serargi The only way this doesn't work is if the user built the report off the dataset in the Service rather than in the PBIX...
All my tests of altering the report, or making edits still result in the report being overwritten. The only other thing I could think of is that the dataset names have a space in them that make them different before or after.
