Forum Discussion
Semantic Model can not add additional data
- 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:
- 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.
For your reference.
https://learn.microsoft.com/en-us/power-bi/connect-data/service-dataset-modes-understand
- toadle9 months agoRegular Visitor
I don't see anything that would help with my problem?