Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ParsaOmidvar
Frequent Visitor

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?

1 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/

View solution in original post

2 REPLIES 2
Akash_Varuna
Responsive Resident
Responsive Resident

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

 

 

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/

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Top Kudoed Authors