Forum Discussion
Sharepoint/onedrive image url without Login credentials.
Hi all,
Numerous posts discuss how to display images in Power BI from SharePoint using URLs. However, these methods typically require users to have access to the files in SharePoint. As a result, for users without access, the images appear broken in their reports when shared. While storing the data in a public location is an alternative, it would be ideal to keep the images in SharePoint and ensure that all users with whom the report is shared can view the images, regardless of whether they have access to these image files or not.
Is there a way to do it?
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
4 Replies
- christinepayton
Most Valuable Professional
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- christinepayton
DAX 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/
Hi San_Raz
The image url has the following limitation:
The URL must be anonymously accessible, not on a site that requires a sign-in, such as SharePoint or OneDrive for work or school.
You can refer to the following link.
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-images-tables#considerations
So the best way is to put the image at a public website so that the user can see the image without any authentication.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
