images into report builder
2 Topics
Showing Offline Images IN Live Connection
I want to show images in a table. I have the binary text stored in sql server. I tried to import in a Olap Tabular and change the binary to text to convert it to BASE64 but this will not work cause the text is too big to be stored in one cell. i tried to write a measure to concatenate rows but Live Connection Does not support Measure Category for me to set that as a ImageURL. Is there any way to show offline images using live connection?Solved770Views0likes2Comments
Inserting images from company sharepoint folder to Power BI Report Builder (Not Working)
I am trying to insert images into a Report Builder report, the img source is a URL to a SharePoint folder but when the report is run no image appears. I have tried running the report (non-locally) hosted in a power bi workspace but that didn't work either. My settings: In Report Builder I have the imagebox properties set to 'external' and the field expression does pull in the correct URL (I copied the expression into the tooltip to check if the URL was correct). If that URL is put into my browser the image loads in there with no issue. What I've tried: - I've tested the report with a random image URL from the web and that works fine. - Tested hard coding the URL directly into the expression field but no luck there. - Followed MS guide :Add an external image to a paginated report (Report Builder) which didn't work since I do not want anyone with the SharePoint link to be able to access it. - I've tried converting the images in to Base64 formats and storing those but I can't do that because the datasource for the report is an MS List table and the character limit on those cells is too small to store image Base64 strings. I support I could split the Base64 string across multiple columns but unsure how to do this. I'm guessing the problem comes due to authentication issues between report builder and SharePoint but I don't know for sure. Any help or alternative method advice would be greatly appreciated!Solved1.6KViews0likes1Comment