unable to publish a report and replace the existing report (AAS to XMLA)

[cw-gprakash]

hi,

We tried to migrate the AAS model into powerbi (using xmla) and reconnect all our reports from AAS to the new powerbi dataset. All these are done in Dev and planned to be deployed to PROD.  In PROD, we don't want the users to lose their personal bookmarks  while we would have replaced the AAS connection to Powerbi(xmla).

Step1: 'Salesorder' report was live connected to AAS model called 'Sales_model'. We imported the AAS into powerbi using xmla and created the dataset called 'Sales_Model_xmla'. Also copied the report and renamed it to 'Salesorder_xmla' which is now connected to  'Sales_Model_xmla'.  At the end we got two reports one connected to AAS and another to xmla powerbi dataset

Step 1	Report	backend dataset
Current	Salesorder	Sales_Model
New	Salesorder_xmla	Sales_Model_xmla

Step2: We did changes in  'Salesorder_xmla' and initially planned to rename it to 'Salesorder' replacing the existing report assuming promoting the new 'Salesorder' to PROD will retain all the bookmarks from the users. Later we found out that when we renamed Salesorder_xmla to Salesorder , it end up creating a new report and we had two copies of 'Salesorder' - one connected to AAS(Sales_Model) and another connected to powerbi dataset (Sales_Model_xmla) because the dataset ids are different for these 2 reports.

Step 2	Report	backend dataset	dataset id/report id
Current	Salesorder	Sales_Model	xyz
New	Salesorder	Sales_Model_xmla	abc

Step 3: After discussing with experts, we understood we need to disconnect the Salesorder from the AAS model and reconnect it to Sales_Model_xmla powerbi dataset using Reports - Rebind Report In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn.

this way I can replace the existing 'Salesorder' and keep the same report id/dataset id

Step 3	Report	backend dataset
Current	Salesorder	Sales_Model_xmla
New	Salesorder_xmla	Sales_Model_xmla

Step 4:

now downloaded new 'Saleorder_xmla' report . there were two options while downloading- first one was greyed out and by default the download option selected was 'A copy of your report with a live connection to data online (.pbix)' . Renamed the report to 'Salesorder' and published it expecting it to override the existing report but got a error-Couldn't publish to Power BI - A report has already been published with this name. Please rename your file and publish again'.

Now I am looking for help on

1. how to download with first option - 'A copy of your report and data (.pbix')

2. Or what are the options to override the current report with new report and still keep all the bookmarks.

[Anonymous]

Hi @cw-gprakash ,

This is a known limitation:

1.Reports created in the Power BI service that are based on a single dataset that's configured for large models or incremental refresh, or that has been modified by using the XMLA endpoint can only be downloaded in live connected report mode.
2.If you create a Power BI report based on a dataset in one workspace and publish the report to a different workspace, you can download the report in live connected report mode only, if the dataset is configured for large models or incremental refresh, or it has been modified by using the XMLA endpoint.

For more you may refer to Download a report from the Power BI service to Power BI Desktop - Power BI | Microsoft Learn

Best regards.
Community Support Team_ Caitlyn

[NatarajanManiva]

@Anonymous , Thanks for your quick response .but i have a question ,if we download a report from service using the second option (Copy of the report with live connection to the dataset ) and do the changes to the report and publish back to the service it should ideally replace the report in the workspace right ? unfortunately while publishing we are getting the error "A report has already been published with this name. Please rename your file and publish again".

I can also find some similar issues in the community site with the same error :

https://community.powerbi.com/t5/Desktop/Publishing-to-Power-BI-This-report-was-already-published-to-the/m-p/103470#M46011

https://community.powerbi.com/t5/Desktop/this-report-was-already-published-to-the-selected-destination/m-p/101226

Any help on this will be appreciated. 

Thanks 🙂

[BIB_Lorentz]

I have the same issue. I have tried changing dataset and downloading file in both ways from the service, but I'm unable to replace existing report. If I delete the existing report and upload with the same name, all existing links break. 

[jfgovern]

Same problem here - has a workaround been identified yet?