The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.