Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Hi @Tamras ,
is your problem solved?
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |