Change report live connection dataset and publishing won't replace existing report like it should

[noahh]

I have a disconnected dataset that I use for "thin reporting". I have multiple reports connected to this live dataset. I then published this same dataset to another workspace (DEV). Then I point an already existing report to this data set and then publish into its original workspace, it does not overide the current report. THe name is the exact same. The only different is that the dataset it is pointing to has changed. I need to be able ot switch back and forth between the two datasets (which are the exact same, just DEV has more rows). I can't delete the report and use the new one because then bookmarks are lost for my 500 users. Any help is greatly appreciated.

[Tutu_in_YYC · Accepted solution]

If you have Power BI admin role, you can use this Power BI Rest API to rebind report to a different dataset

https://learn.microsoft.com/en-us/rest/api/power-bi/reports/rebind-report-in-group

[GilbertQ]

Hi @noahh 

When you change the data source in a report or dataset internally the PBIX is a new file. So even if the PBIX file is the same name, because the data source has changed it is effectively a new report.

I cannot think of any other way around this, maybe someone else will!