Forum Discussion
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
Hi Anonymous , 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.
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!
3 Replies
- dhruvinushah
Responsive Resident
Hi Anonymous ,
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?
- dhruvinushah
Hi Anonymous , 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.
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!