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

);

Thanks in advance for anwering this simple question. 

[jflo08]

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.

[lbendlin]

You seem to have insufficient permissions?

[nikhil_kumbhare]

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

[lbendlin]

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 .

[nikhil_kumbhare]

Thanks for Suggestion. Raised an idea. 

[tegrus-coutinho]

Did you manage to resolve the problem? @nikhil_kumbhare 
I'm facing the same error.

[Chandani_Harshi]

I am also facing this same issue. Don't know how to resolve it.