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
That applies to the Warehouse from the Blog Post. And the way that he is connecting is using a .Net App which unfortunately will not work in the Power BI Service.
Hi GilbertQ ,
Mmm he is also connecting to the Lakehouse SQL Endpoint through SQL Server Management Studio using Service Principal. This is exactly what I'm trying to do. Well, it doesnt' matter if I create the connection from SQL Server Management Studio (I've also tried it) or from Fabric. At the end, what I'm trying to create is a connection to a SQL Analytics Endpoint string with a Service Principal authentication. But I can't.
Just check the post:
1. He gives SP acces to the Lakehouse (in my case, I have given access SP to the whole workspace with Contributor role):
2. Create the connection thorugh SQL Server Management Studio, indicating Server as SQL Endpoint and Authentication as SP:
Regards.
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.