Retrieve user photo from Salesforce into Power BI?

I'm trying to retrieve user's profile photos from Salesforce and pull them into some Power BI reports. I have an image url that points to: https://mycompaniesinstance.salesforce.com/profilep...

Need Help

danextian
8 years ago
Hi anktaggrwl,

I've had the same question before but never bothered to ask for possible solution as adding the images to my report was not necessary. One thing I've realized in my recent Power BI report developments is that if access to something requires authentication, you may not be able to view it in Power BI desktop even if its category has been set to image URL. It could be because PBI desktop is using IE/Edge and you authenticated to SFDC using a different browser. That being said, try uploading a dummy report containing the image URL to your own workspace and edit that report in the service. Then check whether the images render but make sure you've authenticated already authenticated.

anktaggrwl

Kudo Collector

8 years ago

danextian SUCCESS!!

It makes sense that you'd have authentication passed based on the user logging into the report for the images - and since all of my users would naturally be authenticated via their own credientails and SSO into Salesforce in our org - it looks like the images work on the service, and I assume the user that is accessing the report has his/her credentials passed to SFDC when the images are retrieved as they view the report.