Images not showing in report view

[Rach1960]

Hi - use PowerBi in my giftshop business to view product and sales information.  My report is set up to asign base64 urls for the product images.  I ensure they are small enough to keep the url within the 32,000 character limit and it works very well.  However I have recently had issues where the base64 url information can be seen in the table view but it is not showing on the table or image gird in the report view.  I have checked that the url is valid and can't see why some images show and some don't.  I've attached a link to an excel sheet showing 2 urls, one (highlighted in pink) works (shows data and image in report visualisations) and one (highlighted in yellow) doesn't.  Any help would be greatly appreciatiated.  Thank you https://1drv.ms/x/s!AjG53h1y7k7xjrx-uARDQZGHPSynGg?e=lEJ4hY 

[Rach1960]

Thank you everyone for your help.  I finally realised that some of the url's were .png not .jpg - this was caused by using an app to remove the background so although the image was saved as .jpg (and this was also the file name which was matched to the image path column in the database) the url was still .png.  Once I created a new column without the file extension and matched it with the name column in the database this sorted the problem.  Thanks again.

[v-linyulu-msft · Accepted solution]

Hi, @Rach1960 
Regarding the issue you raised, my solution is as follows:

1.First of all, you can check that after getting the Base64 code, prefix it with data:image/jpeg; base64, instead of using it as an expression in any calculated column.

Here's a screenshot of what's in question:

Links for details:

Embedding Images in Power BI using Base64 – Some Random Thoughts (sqljason.com)
 

2.Second, you may want to be aware that "even if you paste the correct base64 code, large images usually won't be displayed." So, make sure you use this method with small images"

Here's a screenshot of what's in question:

Links for details:

Embedding Images in Power BI using Base64 – Some Random Thoughts (sqljason.com)
 

3.You can also try that we can upload the image to the server and then display it using the image URL.

Links for details:

Solved: Base64 Images - Microsoft Fabric Community

4.Here are the links to similar questions you hope will help:
Solved: Image-URL not rendering in powerBI Report - Microsoft Fabric Community
Solved: URL Images Won't Display in PowerBI Online - Microsoft Fabric Community

Of course, if you have any new ideas, you are welcome to contact us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.