Change the connection to a different semantic model while preserving the link, sharing, etc.

Hi zeli 

If you're being automatically prompted to create a new report when you publish, it's likely due to a mismatch between the dataset or model name in Power BI Service and the new semantic model you're trying to connect.

To Fix This and Overwrite the Existing Report:

1. Ensure Dataset Names Match:

   • Ensure the new semantic model’s dataset has the same name as the existing dataset in Power BI Service.
   • If the names are different, Power BI will treat it as a new report rather than overwriting the old one.

2. Check Report and Dataset in Service:

   • Go to Power BI Service and make sure the existing report and dataset are in the same workspace.
   • When you publish, it should overwrite the dataset (if the name is the same), and the report will remain linked to that dataset.

3. Publish with the Same Dataset:

   • In Power BI Desktop, click Publish and select the workspace where the existing report is located.
   • Choose Replace if the dataset name matches.

If the dataset names are not the same or there are any structural differences in the model, Power BI will treat it as a new report and dataset.

Key Points:

• Dataset name must match for Power BI to recognize it as the same report.
• If dataset names differ, Power BI will prompt to create a new report.

Let me know if that helps clarify things!

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS