March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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!!!
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.