Forum Discussion

toadle's avatar
toadle
Regular Visitor
9 months ago
Solved

Semantic Model can not add additional data

Hey everybody,    yesterday we set up a semantic model and a corresponding report in a new workspace that me and a colleague are admins for. My colleague created everything and seems to be owner o...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    9 months ago

    Hi toadle,

    Thankyou for the follow up.

    Based on my understanding, your semantic model was published from a PBIX file, which results in a read only model in the Power BI service. Models published this way cannot be edited or have new data sources added directly in the cloud. The Power Query Editor is disabled by design.

    Please consider the following options, which may help resolve the issue:

    1. Open the PBIX in the latest Power BI Desktop and save it to ensure it uses enhanced metadata. Request your tenant administrator to enable “Users can edit data models in the Power BI service” under Tenant settings in the Power BI Admin Portal. Republish the upgraded PBIX. After this change, users with Build + Write permissions will be able to edit the semantic model in the service.
    2. If your workspace resides in Premium capacity, enable XMLA read/write and modify the model using Tabular Editor or SQL Server Management Studio (SSMS).

    If these options are not feasible, continue maintaining the PBIX in Power BI Desktop and republish whenever changes are required.

    Please refer to the links below for further information:
    Edit semantic models in the Power BI service - Power BI | Microsoft Learn
    Semantic model connectivity and management with the XMLA endpoint in Power BI - Microsoft Fabric | Microsoft Learn

    We hope this information helps to resolve the issue. If you have any further queries, please feel free to contact the Microsoft Fabric community.

    Thank you.

MasonMA's avatar
MasonMA
Super User
9 months ago

When you publish a pbix file to Power BI Service, the semantic model/dataset is owned by the publishing user. This means the model becomes a shared dataset, and others can only connect to it, not modify it. Only the original pbix file can be used to add or modify data sources.

 

To make changes, you need to Edit the pbix file in Power BI Desktop (add data sources there) and Republish the updated pbix to the workspace.