Forum Discussion
Employee or Phone Directory
Is there a way to retrieve all 'active/account enabled' users in Office 365 and create some sort of Employee Phone Directory in Power BI?
My first attempt in Power BI is using SharePoint Online "User Information" list as my dataset but the problem is it does not automatically remove "disabled accounts." From this post, I can use PowerShell update this list but I dont have access to it and I wouldn't want to update the list manually. I also explored getting data from Active Directory in Power BI but was told by our global admin not to use Active Directory for whatever reason.
In Power Apps, I can retrieve the data using Office365Users connector but how to I use this data in Power BI?
2 Replies
- mwegener
Most Valuable Professional
Hi Tamras ,
the connector appears to be using Microsoft Graph.
https://docs.microsoft.com/en-us/connectors/office365users/
This sample creates a basic data source connector for Microsoft Graph.
https://docs.microsoft.com/en-us/power-query/samples/mygraph/readme
