Unable to connect to Kusto (ADX) "Access to the resource is forbidden."

[Nestor_Mendez]

I am trying to connect to my Azure Data Explorer database. My user is an Admin on the ADX database as assigned within the Azure Portal and I can run queries fine from within the ADX Queries window. When I sign in via Power BI and try to connect I can see the ADX cluster but not the databases

and If I specify the database directly in the Power BI Connection window, I get the following error...

Unable to connect

We encountered an error while trying to connect.

Details: "Access to the resource is forbidden."

[Nestor_Mendez · Accepted solution]

I found this post

https://stackoverflow.com/questions/58802770/azure-data-explorer-cluster-details-access-to-the-resou...

and that led me to this Azure Documentation

https://learn.microsoft.com/en-us/azure/data-explorer/kusto/management/referencing-security-principa...

and basically, this is what I did to solve the problem which is to add my user as an Azure Active Directory of my database, I don't understand why because I was already an admin user, but I hope this could be useful for someone else.

.add database MyDatabase users ('aaduser=MyUser@MyOrganization.com') 'User (AAD)'