Forum Discussion
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 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/
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/