Get Organisation people image URL's from Sharepoint or Office 365

[suresh_abe123]

My organisation has around 50 Peoples working.I created a power BI dashboard which require to get each people Image URL's.I think all our photos shoud be stored in sharepoint or office 365 accounts.But I cannot find where I can get this URL's.Can someone help me where I can get this image URL's. For accessing that particular links do we need to have any permissions.

[Watsky]

Hey @suresh_abe123 

If you have to get the url direct from Sharepoint you can use

(insertsharepointwebsitehere)/_layouts/15/userphoto.aspx?AccountName=mail@domain.com

 where each user's company e-mail address replaces mail@domain.com. 

https://blog.vitalyzhukov.ru/en/sharepoint-online-getting-user-picture-url

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

[suresh_abe123]

@Watsky  Thanks,,I tried this on placing in a new tab in browser.Basicall from hitting enter I was able to download the photo.So when I use this link in PBI it shows blank.Is it due to that link only support downloading but not previewing? 

[lkalawski]

Hi @suresh_abe123 

If you want to use profile photos, it is worth connecting to Active Directory. There are all thumbnail photos for each employee. There is a connector to Active Directory in Power BI Desktop.
The entire description of obtaining photos is described by Philip here: 

https://radacad.com/add-photos-to-power-bi-from-active-directory

Proud to be a Super User. If I helped, please accept the solution and give kudos!  Linkedin