Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric certified for FREE! Don't miss your chance! Learn more

Reply
phil_mad
Frequent Visitor

SQL Error [24559] [S0001]: Data Manipulation Language (DML) statements are not supported for this ta

‎12-17-2024 06:18 AM

Hi, I created a SQL Database in Fabric and I wanted to insert some records into a table via JDBC. I get "SQL Error [24559] [S0001]: Data Manipulation Language (DML) statements are not supported for this table type in this version of SQL Server.". The same statement works if  I run it inside of Fabric SQL Database SQL console. Any ideas? Is this documented somewhere? Thanks

Labels:
Message 1 of 2
6,024 Views
0
1 ACCEPTED SOLUTION
NandanHegde
Super User
Super User

‎12-17-2024 07:30 PM

You cannot use DML via the SQL analytics end point.

Normal database connection does support DML




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

View solution in original post

Message 2 of 2
5,997 Views
1 REPLY 1
NandanHegde
Super User
Super User

‎12-17-2024 07:30 PM

You cannot use DML via the SQL analytics end point.

Normal database connection does support DML




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com
Message 2 of 2
5,998 Views

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Fabric Update Carousel

Fabric Monthly Update - February 2026

Check out the February 2026 Fabric update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All