Showing Offline Images IN Live Connection

[ParsaOmidvar]

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?

[Akash_Varuna]

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

[ParsaOmidvar · Accepted solution]

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/