Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have a Power Bi table containing images (data category = Image URL).
The images are pulled from a SQL Server database table. All the images in 1920x1280 resolution are displayed just fine.
However, the 6000x3000 images cannot be displayed. If I try to update the PBI table to display the 6000x3000 resolution images, the table says "visualization could not be shown", since there is some error.
The 6000x3000 images are contained in a column with data type [image] in the SQL server table. There is nothing wrong with the high-resolution images, since I also tested them in PowerApps! NO issues with loading the 6000x3000 images in a Power App gallery.
What is the issue at play here?
Note: Resizing the resolution to 3000x2000 pixels works. Every 1000 pixel range above this appears to not work. Is there a pixel limit in Power Bi set to 3000x2000?
Hi, @msuser48
There is a hard limit on the size of text-field (32766 characters) that can be stored in PowerBI.
So once you've converted your image to a Base64 string, if the length of the string is greater than this then the image will not display properly.
Please check if the solutions mentioned in the below threads could help.
Storing Images in a PowerBI/Analysis Services Data Models
Storing Large Images In Power BI Datasets
How-to-use-Images-Stored-in-a-SQL-Server-Table-with-Power-BI
Best Regards,
Community Support Team _ Eason
Hi @v-easonf-msft , I am aware of the character limitations of Power Bi. I have already used a method to simply split the text rows for the image, and then make a measure to concatenate them. This works just fine for images that have a total of even 80k characters.
But there is something that just doesn't work for images beyond a certain resolution, it seems.
User | Count |
---|---|
64 | |
59 | |
47 | |
33 | |
32 |
User | Count |
---|---|
84 | |
75 | |
56 | |
50 | |
44 |