Service Principal for semantic model authentication from SQL Analytics Endpoint

Hi amaaiia 

As mentioned, I don't think service principles are currently supported

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.