Forum Discussion
Service Principal for semantic model authentication from SQL Analytics Endpoint
I confirm that IT IS possible, both to connect to SQL Endpoint through Management Studio, and to create a connection to a SQL Endpoint by authenticating with Service Principal.
Management Studio:
1. I Copy SQL Enpoint Stirng from Fabric and paste it as Server Name. The I enter service principal values:
2. Connect and:
Success.
New connection in Fabric:
1. From connections pane, I create the new connection with Servive Principal authentication:
2. I have one report accessing data in direct lake mode from a semantic model:
3. In semantic model settings, I change the data source connection as the new serv_princ_conn:
5. I can refresh the semantic model and I can see the data in the report.
So yes, it seems Service Principal is working.
Hi amaaiia
As it stands today, it is not currently possible to use service principles to connect to the sequel endpoint I have read that this will change in the future, but for now you would need to use your personal account to connect.