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

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

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.

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.

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

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

Create Notebook: