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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Kudoed Authors