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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
amymc
Frequent Visitor

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

I am getting the following error: The external policy action 'Microsoft.Sql/Sqlservers/Databases/Schemas/Tables/Create' was denied on the requested resource. when i try to create a table in warehourse. I am an admin of the workspace and have been since before creating the warehouse as i know that was the issue here. I am using a view which i have created in warehouse and another table which i have imported from a csv into fabric using dataflow gen2. i have no issue creating views only tables.

 

I know there were similar issues here 

 

Thanks for the help.

1 ACCEPTED SOLUTION
v-huijiey-msft
Community Support
Community Support

Hi @amymc ,

 

Please try the following steps:

 

  • Check that you have the permissions required for the particular warehouse you are trying to create a table for.
  • Try recreating a warehouse and then creating the table in it to see if the problem persists.

 

If you have any other questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

View solution in original post

2 REPLIES 2
adm_vk_fabric
New Member

Hi Community,
I signed up for the trial today and created a new lakehouse. I have connected dataverse and f&o Table via synapse.Created view Works fine . But when i am trying to take snapshot of the views it throws me error. I try creating table via Notebook it works fine. also run pyspark script in notebook to take snapshot but fails to take, throws the below error. I'm connecting my warehouse in SQL Server Management Studio, but get the same error when trying to capture snapshot of the Views.{The external policy action 'Microsoft.Sql/Sqlservers/Databases/Schemas/Tables/Create' was denied on the requested resource.}Looking for some guidance here.

v-huijiey-msft
Community Support
Community Support

Hi @amymc ,

 

Please try the following steps:

 

  • Check that you have the permissions required for the particular warehouse you are trying to create a table for.
  • Try recreating a warehouse and then creating the table in it to see if the problem persists.

 

If you have any other questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors
Top Kudoed Authors