Forum Discussion
"Insufficient permissions" while saving changes to semantic model via TOM (Tabular Object Model)
Hi Anonymous ,
Check with your Power BI / Fabric Administrator whether new security or governance policies were applied recently.
If you’re using service principals or automation to save semantic models, new consent and security checks may now block saving unless explicitly approved in the tenant settings.
Check in the Power BI Admin Portal if you have access:
Go to Admin Portal > Tenant settings > Export and sharing settings
Look under: “Publish datasets”, “Allow semantic model editing”, etc.
Create or edit a new test model in the same workspace. If that works, the issue is likely dataset-specific permission or ownership, not workspace-wide.If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra.
Community SupportHi Anonymous ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra.
I have a few more details and questions:
We've created a report using a SQL Database as the data source. The service principal has admin access on that SQL Database.
The report is published to a workspace where the service principal also has admin access.
Despite this, the service principal still encounters the "insufficient permissions" error when trying to save a new measure or table using TOM.
Given the above setup, what else could be causing this permission issue? Is there a way to confirm whether the service principal has the necessary "Use permissions" on the data source connection used by the dataset?