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 during AI Skills Fest. This week only. Secure your voucher now.

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,990 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
6,963 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
6,964 Views

Helpful resources

Announcements
June Fabric Update Carousel

Fabric Monthly Update - June 2026

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

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

View All