Report getting duplicated while publishing

[Pawan_123]

Hello, Team.

I have a report published to one workspace which is created with live connection to a semantic model published in another workspace.

This report is in the production workspace and refers to a model in the development workspace, however all reports in the production workspace should only refer to models in the production workspace.

I'd want to update the model to which this report refers; to do so, I downloaded the report from the service in live connection mode and opened it in desktop. I changed the model from development to production, as referred to in this report, and published the report again in the same workspace. While publishing, the replace option is not displayed, and the report is duplicated.

I'd like to know if this is the expected behavior or if there is something I'm missing.

[anmolmalviya05 · Accepted solution]

Hi @Pawan_123, Hope you are doing good !

This can happen due to several reasons:

1. Dataset and Report Relationship: Power BI distinguishes between datasets and reports. When you change the dataset to which a report is connected, Power BI may treat the report as a new entity, especially if the dataset resides in a different workspace.

2. GUIDs and Identifiers: Each dataset and report in Power BI is identified by a unique GUID. When you change the dataset (even if the schema and data are identical), the report's connection to the dataset might be considered a different object.
   
   

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

[davidding]

yes, this behaviour is expected. two reports with different "data source names" can have the "same report name" in the same workspace. Since there is no new dataset created with Live connection, two reports can have the same name. This is obviously confusing and should be avoided, but it has always been allowed.