cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sp_mike
Helper I
Helper I

Connect to O365 user profiles

In a BI dashboard I want to show User profile data of all my users.

How can I connect to the O365 user profiles?

 

Thanks, Mike

7 REPLIES 7
Anonymous
Not applicable

Hello there, Has anybody found a solution to get O365 user profiles data? I'm particularly interested in a user profile picture, since it's the only datasource where our employees photos are maintained. 

 

I know this query is several months old now, but I've found the answers as follows:

 

1). Import SharePoint list - or other suitable source if required

2). Import user profile information: 

2.1). Get data with OData type: https://sharepointsitename.sharepoint.com/_vti_bin/listdata.svc (change sharepointsitename to your site name)

2.2). Select the list “UserInformationList” and load the data.

3). Join SharePoint list you imported in Step1 to user profile info you get in Step2: Go to Manage Relationships function in Power BI Desktop.

 

My source 

v-micsh-msft
Microsoft
Microsoft

Hi sp_mike,

 

Could you please explain a bit for what data that you would like to get into Power BI from the User Profiles, or just as an O365 admin, to monitor the office 365 users in Power BI?

Office 365 team has announced a new Office 365 content pack for Power BI, please take a look at it and see if that would meet your requirements:

Announcing the preview of the Office 365 adoption content pack in Power BI

If you are interested in that, you need to sign up for the preview program:

"

The limited preview of the adoption content pack is available for Office 365 customers today. To get access to the content pack, please send an email to O365usagePowerBIPreview@service.microsoft.com and include your tenant ID. Sign-up closes October 16, 2016and space is limited—so please sign up now. After we have prepared your data (it can take 2-3 weeks), you will receive an email with instructions.

The adoption content pack will become available for all customers to opt in by the end of December.

"

If any further help needed on this, please post back.

Regards

Hi Michael,

 

On my dashboard I have certain figures that must be drilled down from company level, to department level to person level. On this person level I want to show some common information about this person, like phone, room number, if possible a picture, etc.

 

For example. I am a manager and check some figures concerning one of my people (let's say some sales figures). When I see the figures I want to ask some questions. So I need information about this person. Or maybe contact directly from Skype.

 

I hope this makes it a bit clear.

 

Thanks, Mike

Hi sp_mike,

We could build a new Visual to display the Person information, the User contact information from the Office 365 should be obtained from the Exchange server, we could try to get the user data from Exchange, or Active Directory. Then use the User data to build another Visual.  Just drill down through the sales Visual, currently I don't think this is possible.

By the way, showing images in Visuals through the data source currently is not supported in Power BI, this should work in Excel Power Pivot.

Or you may consider submit an idea regarding this part, through the following website:

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards

 

When I connect to exchange online I can only optain my contacts. What I need is all O365 users. Azure AD might be a solution but how do I connect to Azure AD from power BI?

 

Thanks, Mike

Hi Mike,

 

Please check the article below and se eif it would help:

Azure Active Directory and Power BI

By the way, owuld it possible to get the user list from Active Directory?

Power BI and Active Directory for system Administrators

Regards

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!