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

[nikhil_kumbhare]

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 (Read, Write, Reshare, Execute, ReadAll, ViewOutput, ViewLogs) 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. 

[Anonymous]

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]

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.

[guruper]

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]

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]

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

[TimoRiikonen]

Create Notebook: 

%%sql

CREATE TABLE Measures (

    ID BIGINT NOT NULL,

    Col1 VARCHAR(255)

);