Forum Discussion
mjfulke
Microsoft Employee
8 years agoHow to use Images Stored in a SQL Server Table with Power BI
Power BI has several options to display images in a report or dashboard but they mostly require that the image is a url to a publicly accessible website. What I'll show you in this post is a way ...
- 8 years ago
Yes you can. See this article https://blog.gbrueckl.at/2018/01/storing-images-powerbi-analysis-services-data-models/
mjfulke
Microsoft Employee
7 years agoSounds like the length of the datatype you're using ends at 1024. Look at varchar(max)
admin_xlsior
Post Prodigy
7 years agoSorry, 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. :(