Forum Discussion
Sharepoint/onedrive image url without Login credentials.
The one workaround you can do here is if you can translate the images to base64, then pull that into your dataset, Power BI can display the image from the base64 code instead of pulling from the URL. The issue I run into is that the base64 code often exceeds the maximum character limit for fields... I think if your images are smaller, it can work though. There's a few videos out there on this on YouTube - here's a link to one of them: https://youtu.be/dPR46gEADBU?si=phIBCY6cLal-lMZB
Thanks christinepayton ,
I converted the sharepoint images to Base64 and as you mentioned there is a limitation to the number of characters stored in each row (32766 character limit). However the workaround for this is provided by Chriss Webb https://blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/.
Now the images are getting loaded fine, my only worry is as the size of the data set gets larger, I don't know how it affects the performance of my dashboard
Most Valuable ProfessionalDAX Studio can show you the size of the columns if you want to check how much space they're using - I would try to use small size photos, too, not full-size if possible: https://daxstudio.org/docs/features/model-metrics/