service principal as datasource credential?

[jessegorter]

hi,

i am using power bi premium to host analysis services models.

it is possible to use a service principal to acess the underlying database, which is synapse?

I cannot seem to login as a service principal to set this up. I do not want to use my own account as the credential accessing the underlying datasource. And it seems strange to use oldschool database account for this.

How do you do this? Or do you create a service account in azure for this?

Greetings

Jesse

[v-xulin-mstf]

Hi @jessegorter,

The user name of AS credentials must match a defined user principal name (UPN) within the local Active Directory domain.

If you want to make service principal as datasource credential, service principal need to be in local Active Directory domain.

For more information about AS authentication requirements and mapping rules, you can refer：

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-ssas

Best Regards,
Link

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

[jessegorter]

Hi, nothing is on premises here. It is a visual studio .bim file which we hosts in Power BI Premium. However, in the dataset i cannot login as a app registration

[v-xulin-mstf]

Hi @jessegorter,

Is your issue solved?

If the issue has been solved, please adopt the solution to help others.

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[v-xulin-mstf]

Hi @jessegorter

Sorry for delay reply.

Please refer:

For more information, you can refer:

Connect to Visual Studio Team Services with Power BI | Azure DevOps Hands-on-Labs (azuredevopslabs.c...

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!