Paginated Report Image Display Error

SQLJiim — Tue, 10 Sep 2024 19:41:47 GMT

I am trying to display an image from the AdventureWorksDW database on a paginated report and all I get is a box with a little red 'x' in it. The image is in a varbinary(max) column.

My query is simple: SELECT FirstName, LastName, EmployeePhoto FROM [dbo].[DimEmployee]

My image properties are as follows:

I have tried all of the different mime types, but same result. What am I doing wrong?

SQLJim

Re: Paginated Report Image Display Error

Anonymous — Wed, 11 Sep 2024 05:24:14 GMT

Hi,SQLJiim .I am glad to help you.

According to your description. When you place a picture from the database to display in a table in a paginated report, you find that the picture cannot be displayed properly after clicking Run.
There are restrictions on displaying image resources in Power BI paginated reports.
1. The picture format type needs to meet the conditions.
2. There are restrictions on the display size of the picture, generally do not support too large a picture (generally 2MB-4MB for the appropriate range), may cause display problems.
3. Please check whether your picture path is correct.
What is the actual way of storing pictures in SQL Server database, is it the path of the stored pictures (in the form of complete URL, using other character types such as VARCHAR), or the pictures are stored in the database as binary data (such as VARBINARY(MAX) type).
Please check whether the image stored supports displaying in paginated reports.
4. Make sure that your data source itself stores the picture information data without corruption and has the right to access this information.

Below are the related documents and resolved issues I have found on displaying pictures in Power BI paginated reports, I hope it will be helpful to you.
URL:
Images in Power BI paginated reports - Power BI | Microsoft Learn
Add an external image to a Power BI paginated report - Power BI | Microsoft Learn

If you use URLs to store image information, you can refer to this issue
Solved: Display Image URLs as Image in Power BI Paginated ... - Microsoft Fabric Community
These are the issues that have been resolved by other users in the forums about images in Power BI paginated reports not displaying properly

Solved: Power BI Paginated Report Image doesn't display - Microsoft Fabric Community
Solved: cannot display image in paginated report. - Microsoft Fabric Community
Solved: Re: How to display Base 64 PNG images from a datab... - Microsoft Fabric Community

If you can provide more specific information about what your image is not showing (including screenshots, etc.) this will help you pinpoint the problem quickly!

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: Paginated Report Image Display Error in Report Server

Paginated Report Image Display Error

Re: Paginated Report Image Display Error