How to Identity and Access management Power BI services with Azure Data Explorer (ADX)?

Question

I have an Azure Data Explorer that the Power BI services (Data Source) connect to the ADX with personal user credentials.

Also, I have to add this user in Azure Data Explorer permission. Now I want to know, is there any way to remove the user account and use another solution like Service Principal or Manage Identity?

Answer 1

@Mohsen Akhavan Welcome to Microsoft Q&A forum and thanks for reaching out here.

As per below document, only organizational email account that is member of AAD can be used to authenticate Azure Data explorer clusters from Power BI. That is the only supported authentication type.
Related doc:

1. Power query Connector reference - Azure Data Explorer

1. Power query Connector reference - Azure Data Explorer

You may log a feature request in Power BI feedback forum here: visit the Power BI ideas forum.

If you have further questions regarding power BI, please utilize Power BI dedicated forum: Power BI Community

Hope this information helps.

---

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.