topic Showing Offline Images IN Live Connection in Report Server

Showing Offline Images IN Live Connection

ParsaOmidvar — Mon, 03 Feb 2025 06:37:34 GMT

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?

Re: Showing Offline Images IN Live Connection

Akash_Varuna — Mon, 03 Feb 2025 10:31:24 GMT

Hi ParsaOmidvar , Power BI doesnt natively support BASE64 could you please try these

Convert binary data to BASE64 in SQL Server and store it as an ImageURL column.
Update the OLAP model to include the ImageURLfield for use in Power BI.
If BASE64 is too large, host images in Azure Blob Storage and store URLs in SQL Server.
Use paginated reports or custom visuals for better image handling in live connections.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance

Re: Showing Offline Images IN Live Connection

ParsaOmidvar — Mon, 03 Feb 2025 13:33:24 GMT

The Thing is they are too large and i can't Use Azure blob storage cause the report is on a machine with no internet access, I finally did it using a local HTTP server using python
https://bizkapish.com/power-bi-desktop/local-image-server-for-power-bi-desktop/