Forum Discussion
Images stored on SharePoint broken image icon
So, I have created a report pulling images from attachments to List items. I get the fully formed URLs which, when I categorise them as Web URL and click on them they open an image. I then change the category to Image URL and then I get a broken image icon for each of the images. After watching the Youtube video mentioned several times in this forum: https://www.youtube.com/watch?v=FpZgUPPtHtY I published the report hoping the images would show up. They don't. In the service, I still get broken image icons.
To test whether the issue was just because I was trying to use images from List attachments, I created another data source based on images from library items, the same way the video author did. However, even for those I still get the broken image icons, even in the service.
I have seen quite a few people on this forum asking about this and most seem to point to that video for a fix. However, I have not seen anyone come back with a definitive answer.
Is it true that, despite the fact I can click on the URL, so it proves I have access to the files, Power BI will not display the images if they are stored on SharePoint? I really don't want to give the world access to my HR list so I can access these images per this request: https://community.powerbi.com/t5/Desktop/Images-stored-in-sharepoint-list-office-365-group-showing-up-as/m-p/1938045
12 Replies
- lbendlin
Super User
Yes, this seems to be a popular issue lately. Have you considered including the images in the pbix as part of the import process?
lbendlin, thanks for your response. No I hadn't considered that and I don't know how to do it. Are you able to point me to a resource to start me off?
Finding it pretty frustrating that a M$ product cannot display resources stored on M$ infrastructure.
- lbendlin
this should get you going: https://blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/
Hi KarlOnEarth did you get a solution to your problem.
I have the same problem.
- I can successfuly view an external image from a public URL in a powerbi visual where the URL is of type "Image URL". Works fine.
- I copied this exact same image onto my sharepoint 365 portal and placed in a normal folder with other images and non image files.
- In the power bi visual, I can click on the web URL of the image location in sharepoint and the image will appear in a browser window.
- In the same power bi visual, I have a copy of the web URL of the image location in sharepoint configured as data category "Image URL", but only the broken image icon appears.
- The image is a jpeg.
- The sharepoint folder is shared with anyone.
I can't figure it out.
Hi Maprock, no solution yet sorry. It appears that Microsoft don't yet have the technical expertise to make this work. All I can suggest is to pray that they might be able to find and employ someone who can make it work for them.
I think I may have FINALLY figured this out. I have spent a lot of time trying everything and the solution that worked for me was very simple in the end.
In Edge (haven't tried Chrome)
1. Before going to your report, login to Office 365 (https://www.office.com/)
2. Navigate to your SharePoint site and log in if prompted (redundant to previous step)
3. Log in to your report
I cornered the issue to something with cookies and for whatever reason logging into O365 seemed to correctly place the cookie for PBI to access SharePoint.
Hope this helps!- lbendlin
How much of a solution is this? What's the maintenance effort? These cookies expire/get purged etc.
It's a band-aid at best, and shouldn't be implemented as a solution. I was hoping it could be a start to an actual fix because thus far, I haven't come across any answer that resulted in an image being displayed successfully.
