Notifications
Announcements
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?
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.CheersIf you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help othersThank YouMichael Gernaey MCT | MCSE | Ex-Microsofthttps://gernaeysoftware.comLinkedIn: https://www.linkedin.com/in/michaelgernaey
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 525 Super User 2025 Season 2
Tomac 425 Moderator
abm abm 245 Most Valuable Professional