how to connect to a Fabric semantic model from SSMS

[Jeanxyz]

I can open a Fabric warehouse from SSMS with no problem, but when I try to connect SSMS to a semantic model in Fabric workspace, I got an error. I find the connection string in Semantic dataset - settings - Server settings. Below is my login at SSMS and error message. 

Thanks!

[v-saisrao-msft]

Hi @Jeanxyz,

Please use Analysis Services as the Server Type instead of Database Engine in SSMS — that worked for us when connecting to a Fabric Semantic Model. The issue occurs because the XMLA endpoint requires the Analysis Services protocol.

For more details, you can refer to the official Microsoft documentation here:

Troubleshoot XMLA endpoint connectivity in Power BI - Power BI | Microsoft Learn

If this post helps, then please consider Accept it as a solution to help the other members find it more quickly.

Thank you.