Forum Discussion
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:
7 Replies
You seem to have insufficient permissions?
Thanks for revert.
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.
I am not sure whether it is related to Trail account or something else.
Thanks
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .
I have had a similar issue, and unforuntately I still haven't found a resolution for creating a SQL query to manualy create a table in my warehouse. What I was able to do though for my metadata was create a warehouse only. It might be a good option to use only a warehouse if really you don't need a lakehouse functionality.
