Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

The external policy action 'Microsoft.Sql/Sqlservers/Databases/Schemas/Tables/Create' was denied

Hi All,

New to Fabric and Power BI using Trial version of fabric. 

Created few workspaces including Lakehouse and warehouse. Tried to create a table using simple statement in available warehouses but getting below error message:

Started running query at line 1
The external policy action 'Microsoft.Sql/Sqlservers/Databases/Schemas/Tables/Create' was denied on the requested resource.
Msg 368, Level 14, State 1, Code line 1
Statement ID: {D09E01E2-894E-4604-813D-026F88D8C580}
Msg 24528, Level 0, State 1, Code line 1
 
SQL Query:
CREATE TABLE [dbo].[V_Date]
(
    [DateID] int NOT NULL,
    [Date] date NULL
);
I have "Workspace Admin" role with permission (ReadWriteReshareExecuteReadAllViewOutputViewLogs) for all of the Warehouses created. I have created a new warehouse and could execute same statement. But couldn't execute in warehouses which I had created yesterday. 
Status: Investigating

Hi @nikhil_kumbhare ,

 

Please ensure that the warehouse where you’re trying to create the table has the necessary permissions. You might have the permissions on a new warehouse, but not on the ones created earlier. you may check whether the data source corresponding to your report (such as Fabric Warehouse) has given the correct permissions.
The error message mentions an external policy action being denied. This could mean that there’s a policy in place that’s preventing the creation of tables. You might need to check with your administrator if there are any such policies.

Best regards.
Community Support Team_Caitlyn

 

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi @nikhil_kumbhare ,

 

Please ensure that the warehouse where you’re trying to create the table has the necessary permissions. You might have the permissions on a new warehouse, but not on the ones created earlier. you may check whether the data source corresponding to your report (such as Fabric Warehouse) has given the correct permissions.
The error message mentions an external policy action being denied. This could mean that there’s a policy in place that’s preventing the creation of tables. You might need to check with your administrator if there are any such policies.

Best regards.
Community Support Team_Caitlyn

 

GregMarbais
Advocate V

I'm getting the same error message when trying to create a table from a Data Warehouse. I am the Fabric admin for my company and have workspace admin permissions set.

Here are what my permissions are at the data warehouse level - although I don't see any way to edit them.

GregMarbais_0-1709848685792.png

 

guruper
Regular Visitor

I signed up for the trial today and created a new lakehouse. I'm connecting my warehouse in SQL Server Management Studio, but get the same error when trying to run a CREATE TABLE statement: The external policy action 'Microsoft.Sql/Sqlservers/Databases/Schemas/Tables/Create' was denied on the requested resource.

nikhil_kumbhare
New Member

Hi Guruper,

Please review whether you are connected to Lakehouse (SQL End point) or Warehouse. Create table script will work only in Warehouse. So please select warehouse and then execute the query. 

Thanks

guruper
Regular Visitor

Thanks, I found that out 10 minutes after posting here 🙂