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
josi4
Frequent Visitor

Connecting to fabric SQL endpoint from SSMS

Hi,

I'm unable to connect to my fabric SQL endpoint from SQL Server Management Studio.
This is supposed to be possible right?
Error message below.
Anyone know what I need to get this working?

Thanks

 

josi4_0-1686526190546.png

josi4_1-1686526291911.png

 

4 REPLIES 4
josi4
Frequent Visitor

That doesn't explain it but agree it's odd that INSERT is mentioned in the error text.
The error happens during initial attempt to establish a connection to the SQL endpoint (shown below)

josi4_0-1687125338631.png

 

What's your version of SSMS? Can you try updating to the latest version and try again?

Hi ,  @josi4 

Are you able to connect successfully now? According to your error message "INSERT is not a supported statement type", it means that the SQL endpoint does not support the insert statement.

Creating, altering, and dropping tables, and insert, update, and delete are only supported in Warehouse in Microsoft Fabric, not in the SQL Endpoint of the Lakehouse.

And i test it in my side , i can connect it without any error code .

Did you choose to execute statements or open some windows when you connected?
marcosvin
Resolver II
Resolver II

Hello!

 

From the error message it appears you are executing an INSERT command in a lakehouse, which is not supported. Lakehouse SQL Endpoint only allows SELECT queries. To modify data you need to create flows using dataflows and pipelines or use commands directly in Spark notebooks.

What is SQL endpoint for a lakehouse? - Microsoft Fabric | Microsoft Learn

 

To perform DML operations use warehouses instead of lakehouses.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.

Top Solution Authors
Top Kudoed Authors