Forum Discussion
Semantic Model can not add additional data
- 10 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:
- 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.
- 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 LearnWe 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.
Thankyou, mickey64, MasonMA and Kedar_Pande for your responses.
Hi toadle,
We appreciate your inquiry through the Microsoft Fabric Community Forum.
We would like to inquire whether have you got the chance to check the solutions provided by MasonMA and Kedar_Pande to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.
Thank you.
Aren't these two advices contradicting? One Kedar_Pande says it is solvable by setting permissions, whereas MasonMA says it is not solvable. What is correct?