web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get profile image from...
Power Automate
Unanswered

Get profile image from Office 365 then save to SQL database

(0) ShareShare
ReportReport
Posted on by 247

I want to pull profile pictures and then save to SQL server database as Image.

From this post, I save the output of the compose to an image column in SQL database:

https://powerusers.microsoft.com/t5/Building-Flows/Download-User-profile-picture-using-Flow/td-p/1325159

 

yet these formats (bmp, jpeg, png, x-png) all render as red x instead of an image in my report (SSRS). What am I missing?

 

NewBee117_0-1694496534693.png

 

 

Categories:
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    53,932 Moderator on at

    Hello,

     

    Can you do a test.

     

    Go to SQL and grab one of the files (binary data), write it to a file and name it as jpg or png or whatever it is supposed to be and then try to open it in Paint or other editor.

     

    Can you open it and see the picture? I just want to make sure the data is all there. I don't know if it is, or its a headers issue in SSRS but this seems more an SSRS / SQL issue maybe.
    Cheers
    If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
    Thank You
    Michael Gernaey MCT | MCSE | Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • NewBee117 Profile Picture
    247 on at

    Never mind. I got it to work. 🙂

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 112 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 52

#3
Ellis Karim Profile Picture

Ellis Karim 51 Super User 2026 Season 1

Last 30 days Overall leaderboard