Forum Discussion
How to use Images Stored in a SQL Server Table with Power BI
Yes you can. See this article https://blog.gbrueckl.at/2018/01/storing-images-powerbi-analysis-services-data-models/
Hi, I tried same step, and count the character is 1024, but still it is display as broken image. My image is png.
However by look at the character length, I'm not sure whether it is correct, or somehow during convert to text it is truncated ? because quite weird that all in the same length.
Sounds like the length of the datatype you're using ends at 1024. Look at varchar(max)
Sorry, I copy it to Excel and use Len function, not sure why it is give me that 1024.
But I add a Calculated Column directly in Power BI in the same table, turns out it gives me what I think the correct length.
Some variance of length shows, but not exceed 32677, yet it doesn't show me the image instead a broken image icon.
Thinking of giving up as well. :(