Unable to use service principal with Power BI desktop and web

[agenthunt]

Hi,

We have a Kusto cluster with data that we need to report on via Power BI. I have verified that if I add myself to the database as an admin and use my aad to authenticate in Power BI, I can generate the report. However, we would prefer to use service principal or power bi app id (if any) for compliance and security.

Is this something that is supported and can someone share an example? During development time (via Power BI desktop), the only relavant option I see is to use AAD account for authentication to the Kusto cluster. Unfortunately, I am not an admin of the power bi domain we use.

Thanks

-Ravi

[v-xicai]

Hi @agenthunt ,

You may refer to the following documents:

Service principal with Power BI

Register an Azure AD application to use with Power BI

Best Regards,

Amy

Community Support Team _ Amy

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

[agenthunt]

Hi @v-xicai ,

As mentioned previously, I am not seeing an option to update tenant settings in our admin portal. How can I see that?

Thanks

-Ravi

[v-xicai]

Hi @agenthunt ,

The full admin portal is accessible to all users who are Global Admins in Office 365 or have been assigned the Power BI service administrator role. If you're not in one of these roles, you only see Capacity settings in the portal. For more information about the Power BI service administrator role, see Understanding the Power BI admin role.

Best Regards,

Amy

Community Support Team _ Amy

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