Azure AD import to Power BI

[Blackbeard]

Hello friends,

I am trying to import data från Azure AD to Power BI.

I want user data, for example location and No of guest users

I have read a lot of articles about using Microsoft Graph but unfortunately it is no longer supported.

Can anyone please give me some guideluines on how to do this?

Bstrgrds

[dhruvinushah]

Hi @Blackbeard , 
I believe this article will help you get started on the way to getting data from Azure AD into Power BI. It clearly states all the steps you will need to get connected to AD from Power BI. 
Azure Active Directory meets Power BI | Microsoft Power BI Blog | Microsoft Power BI

Hope this helps, tag me (@) if you need more help on it. Feel free to mark the answer as a solution if it helped you.
Thanks!

[Blackbeard]

Hello @dhruvinushah ,

Thank you for your contribution.

I saw this link earlier as well but the Azure Active Directory Logs doesn't seem to exist anymore

Do you know if it has been replaced?

[dhruvinushah · Accepted solution]

Hi @Blackbeard ,  I did not realize that. I did research more on this and I believe you can find this solution by Radacad will solve your problem. 

Import Azure Active Directory Users into Power BI An Step toward Dynamic Row Level Security - YouTub...

That being said you will need administrator access for the above solution to work effectively. 

Another way for you to get the users from an AAD would be to use Synapse to connect to the AAD directly and populate it to a DB. You can then query it directly from the DB into your Power BI report. 

Hope this helps!