Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

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.

1 ACCEPTED SOLUTION
Tutu_in_YYC
Resident Rockstar
Resident Rockstar

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

View solution in original post

2 REPLIES 2
Tutu_in_YYC
Resident Rockstar
Resident Rockstar

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
Super User
Super User

Hi @Anonymous 

 

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!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.