Forum Discussion
SharePoint Image to Paginated Report
Hi Everyone,
I need help showing my SharePoint images from my document library on Paginated Report.
1. I added the document library to my Power BI and have a table showing ID and URL
(URL = websit URL+ ServerRelativeURL | Ex. https//sample.sharepoint/com/sites/TEST/Images/ABC.png).
2. Secondly, I published the upated PBIX file to my premium workspace for Report Builder to read.
Goal: Creat an image subreport that is filtered based on ID parameter inside my main report showing the particular ID's image.
Note: Im struggling to show the image as the "image source" doesnt work. I read some people converted to Base64 and then split but I was struggling on the steps.
Thank you for your assistance 🙂
Hi JoelN ,
For the selection of image resources, if the image resources stored in the report server portal select external.
For images on any website (including report servers in SharePoint integration mode), type the full URL of the image in the "Use this image" box.
https://\<SharePointservername>/\<site>/Documents/images/image1.jpgrelated document link:
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
10 Replies
Hi JoelN ,
For the selection of image resources, if the image resources stored in the report server portal select external.
For images on any website (including report servers in SharePoint integration mode), type the full URL of the image in the "Use this image" box.
https://\<SharePointservername>/\<site>/Documents/images/image1.jpgrelated document link:
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.This solution does not work with images from a sharepoint image library. I need to make a report from the sharepoint list, but the report builder doesn't matter from there. Sharepoint URLs are restricted, even leaving them open to anyone with the link.
In this image square 1 external image from microsoft site.
image 2 external image from my sharepoint image library (open to anyone with the link)Import images to azure data storage - create sql mapping - add in sql table - create view and add in paginated report.
v-henryk-mstf Thank you for getting back to me. I think I need to give you a little more detail on the problem im trying to solve. I created a video and posted here https://screencast-o-matic.com/watch/c3heDVVYd5f.
You will see my logic from SPO to Power BI to Paginated Report. Let me know your thoughts. Thanks!
Hey d_gosbell I saw you have completed some great solutions in Report Builder. If you have a moment I'd love to hear if you think there is a solution to my issue. Thanks!
Video of issue: https://screencast-o-matic.com/watch/c3heDVVYd5f.
Goal: Creat an image subreport that is filtered based on ID parameter inside my main report showing that particular ID's image stored on SharePoint document Library.
Joel
I agree with v-henryk-mstf at 1:57 where you set the image source to Database it should be set to External
This solution does not work with images from a sharepoint image library. I need to make a report from the sharepoint list, but the report builder doesn't matter from there. Sharepoint URLs are restricted, even leaving them open to anyone with the link.
In this image square 1 external image from microsoft site.
image 2 external image from my sharepoint image library (open to anyone with the link)I was able to solve my issue. As mentioned above SharePoint library cant be done. The fix was adding the images in Azure Data storage -> Create a SQL view and create a new dataset from the view created. It worked after that. Hope this helps others.
