Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Blackbeard
Regular Visitor

Azure AD import to Power BI

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

1 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!









View solution in original post

3 REPLIES 3
dhruvinushah
Responsive Resident
Responsive Resident

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!









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?

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!









Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.