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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
nikhil_kumbhare
New Member

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:

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. 
 
5 REPLIES 5
lbendlin
Super User
Super User

You seem to have insufficient permissions?

Thanks for revert. 

I have "Workspace Admin" role with permission (ReadWriteReshareExecuteReadAllViewOutputViewLogs) 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 .

Thanks for Suggestion. Raised an idea. 

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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