topic Re: The external policy action 'Microsoft.Sql/Sqlservers/Databases/Schemas/Tables/Create' was denied in Developer

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

nikhil_kumbhare — Sat, 02 Mar 2024 08:01:48 GMT

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.

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

lbendlin — Sat, 02 Mar 2024 18:01:51 GMT

You seem to have insufficient permissions?

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

nikhil_kumbhare — Sat, 02 Mar 2024 20:21:27 GMT

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

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

lbendlin — Sat, 02 Mar 2024 20:26:55 GMT

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 .

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

nikhil_kumbhare — Mon, 04 Mar 2024 17:19:54 GMT

Thanks for Suggestion. Raised an idea.

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

tegrus-coutinho — Tue, 19 Mar 2024 20:23:05 GMT

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

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

Anonymous — Wed, 23 Oct 2024 12:58:04 GMT

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

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

jflo08 — Mon, 09 Dec 2024 15:16:28 GMT

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.