Forum Discussion

zeli's avatar
zeli
Regular Visitor
1 year ago
Solved

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

Hello, I need to connect the report to another semantic model. At the same time, I need to keep the same link for the report to connect and share the assembly to users. So I need the existing report...
Need Help
  • Poojara_D12's avatar
    Poojara_D12
    1 year ago

    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 

v-kpoloju-msft's avatar
v-kpoloju-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi zeli,

Apologies for the delayed response. Thank you for the update on the issue.

 

Unfortunately, Power BI Service currently does not support transferring sharing settings when switching to a new semantic model but using the overwrite method can help you keep the same report name and link.

 

If it's important to keep the original report's sharing settings and link, here’s a possible workaround:

  • Please download the original report if you haven't already and open it in Power BI Desktop. Modify the semantic model following the steps provided earlier.
  • Save and publish the updated report to the same workspace, ensuring it retains the original report's name. When prompted, overwrite the report to maintain the original link. After publishing, manually reapply the sharing settings for the new report.

 

If this post helps, please give us Kudos and consider accepting it as a solution to help other members find it more quickly.

 

Thank you.