cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OneWithQuestion
Post Prodigy
Post Prodigy

Possible to query Azure AD?

I see that PowerBI has an Active Directory connector, which is awesome!

However, I don't see how to query Azure AD?  The current connector appears to only be on premise AD?

Am I doing something wrong?

Thank you!!!

1 REPLY 1
v-jingzhang
Community Support
Community Support

Hi @OneWithQuestion 

 

The current AD connector is only for on-premises AD. There is an Azure AD Connector for Power Automate and Power Apps, but there is no Azure AD connector in Power BI now. You can vote up for below ideas: 

Microsoft Idea  · Azure Active Directory

Microsoft Idea  · PowerBI connector for Microsoft Graph

 

At present, if you want to use Azure AD data in Power BI, you can try using Microsoft Graph to query data from Azure AD first, then connect to Microsoft Graph to get data into Power BI. 

Working with Azure Active Directory resources in Microsoft Graph - Microsoft Graph v1.0 | Microsoft ...

Easily connecting between Power Query / Power BI and Microsoft Graph | by Chris Hill | Medium

Connecting Power BI to Microsoft Graph | techpeanuts (tech-peanuts.com)

 

Another option may be to use Powershell cmdlets (AzureAD Module) to get data first and export into other data sources. Then connect to these data sources with Power BI.

 

Additionally Audit logs in Azure Active Directory is also a powerful feature. You can filter activities and date ranges to get the data you want and download it into csv files. Then in Power BI, connect to these csv files to get data. 

 

Hope this helps.

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors