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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

1 REPLY 1
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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugFabric_Carousel

Fabric Monthly Update - August 2024

Check out the August 2024 Fabric update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.