Forum Discussion

ParsaOmidvar's avatar
ParsaOmidvar
Frequent Visitor
1 year ago
Solved

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?

Image in DAX
Image URL
images into report builder

2 Replies

  • Akash_Varuna's avatar
    Akash_Varuna
    Super User
    1 year ago

    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