Azure : SSRS Report Server : Image files bulk upload

Ajay Unecha 1 Reputation point
2020-08-21T00:24:19.433+00:00

Hello,

I have created azure release pipeline to upload files, and looking solution to bulk upload .png files on report server.

In a release pipeline, the SSRS task can upload only .rdl files, not .png. It gives MIME type error.

Could you please help to know if there any out of box option/task or other solution available to solve this issue?

Thank you.

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,980 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 13,986 Reputation points Microsoft Vendor
    2020-08-21T03:24:34.69+00:00

    Hi AjayUnecha-7804,

    You can create a Report Server project and add all the images to that project by right-clicking reports-> add -> existing Item and change the file type "All Files" in add existing item window, then deploy this project to a new folder to SSRS web portal.
    19246-1.jpg

    19247-2.jpg

    In addition, you can try to create a table to store all the images there and add a dataset to the report to retrieve an image.

    Please refer to the following articles which might help:
    Bulk uploading images to SSRS
    Rendering images from a database on SSRS reports

    Best Regards,

    Amelia


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.