Forum Discussion
service principal as datasource credential?
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
4 Replies
- v-xulin-mstf
Community Support
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,
LinkIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
- jessegorter
Helper I
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
Community Support
Hi jessegorter
Sorry for delay reply.
Please refer:
For more information, you can refer:
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!