cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
noahh
Helper II
Helper II

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 @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!





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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors