I'm finding that what I would like to do isn't possible, but I just want to confirm:
We have a workspace that had a single report with a cached dataset. Someone made a few copies of that report in Power BI desktop, changed some of the visuals within the resulting reports, and then uploaded those copies into the same workspace. This resulted in three reports that point to three cached datasets that are actually the same dataset (schema wise). I want to update the connection so that all three reports point to the same Power BI dataset. If I do that with Power BI desktop and point the file to the dataset in the service (Live Connection) and then upload the report into the workspace, a duplicate copy of the report is created (It's my understanding that two reports with the same name can exist in a workspace if they have different data connection types, e.g. one with a cached dataset and the other with a live connection). The issue is that I can't publish the new version of these reports because people in our organization might already have a bookmark to the current version of the report and the existing report and duplicated report have different ids within the url.
Is it possible to change the connection of an existing Power BI report from a cached dataset to a shared dataset within the Power BI service? Or, does anyone know of a way to change the connection type (cached vs. live connection) of a report and then overwrite an existing report with the same name in the Power BI service?
Thanks,
Eric
