cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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 2
Highlighted
Super User III
Super User III

Re: Employee or Phone Directory

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

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
twitter - LinkedIn - YouTube - website

Highlighted
Super User III
Super User III

Re: Employee or Phone Directory

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.

 

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
twitter - LinkedIn - YouTube - website

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors