Forum Discussion
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:
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.
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.
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
Hi zeli
To connect your Power BI report to a new semantic model and keep the same link:
- Update in Power BI Desktop: Change the data source to the new semantic model and adjust visuals if needed.
- Publish to the Same Workspace: When publishing, choose Replace to overwrite the existing report and dataset.
- Verify in Power BI Service: Check that the report reflects the new model and test visuals and refresh schedules.
- Shared Links Stay Unchanged: The report URL remains the same for users.
This ensures a smooth transition without creating a new report.
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
Hi,
if I do this procedure, I will not be prompted to replace the report when it is published.
It will automatically create a new report.
Lenka
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:
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.
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.
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