Change data set and update app after some internal error with the old data set

[Lennart_Wallden]

Hi there,

I have a data set that won't update anymore due to some internal error. I published a new version of it, and that one updates fine. I have several reports connected to the old data set, and now I have to replace it. I have tried to change the data set in one of the reports, but it creates a new version of the report instead of updating the existing one.  This report belongs to an app that is distributed throughout the company. 
I have also tried to update the app with the new version of the report, but when I change I got an error message that every object in the app is hidden from the users. It seems that I have to share the report in some way. 

I would like to avoid that everyone in the company should be invited to the report again, or have to install a new app.

Does anyone have any suggestions about:
1) Change the data set in the existing report
2) Replace the report in the existing app

[Lennart_Wallden]

But then it creates a new report with the same name, it will not replace the existing one.

[Anonymous]

Hi @Lennart_Wallden ,

Please open the original report in Power BI Desktop, then change the data source to the new PBI Dataset, then save the report and publish it to Power BI Service, the same name report in the Power BI Service Workspace will replace with the new data source report.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Lennart_Wallden]

Hi @Anonymous 
Thanks for your reply.

That is exactly what I have been doing. Did it again, look at the following pictures.

Workspace before change:

Change of data set in PBI Desktop:

Result in workspace:

And since the first one is part of an app that is spread throughout the company, it is a big problem.

[Anonymous]

Hi @Lennart_Wallden ,

If your reports are created with PBI Dataset, you could change the data source in Power BI Desktop, then save and publish this report to Power BI Service.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.