Forum Discussion
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
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.
essjayemm
Advocate I
Advocate II 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.