topic Re: Display Images In Report Bulder using PowerBI dataset in Report Server

Display Images In Report Bulder using PowerBI dataset

Anonymous — Fri, 04 Feb 2022 10:34:14 GMT

Hello,

My goal is the following: I have to display images, stored in PowerBI dataset into SSRS Report.

The images were converted to Base 64 format and they are displaying correctly in PowerBI desktop.

When I try to load them in Report Builder it's not possible and I receive error.

This is what I've tried so far:

- First - I select insert image --> the value of the Image with base 64 format. The source is "Database" and MIME type "image/jpeg"

- Second - the same thing but instead of the base 64 image I select the text value of the image.

Both give no result.

I also tried the solutions from this post but they didn't work for me -->https://community.powerbi.com/t5/Report-Server/How-to-display-Base-64-PNG-images-from-a-database/m-p/1177424

Can you plese help with this?

Regards,

Vassil

Re: Display Images In Report Bulder using PowerBI dataset

lbendlin — Sun, 06 Feb 2022 22:57:57 GMT

"and I receive an error"

please provide more details and maybe share the error message.

Re: Display Images In Report Bulder using PowerBI dataset

Anonymous — Mon, 07 Feb 2022 08:39:48 GMT

Hello,

Apologies I didn't give enough details.

There isn't error message. I got this red "X"

In a nutshell --> I've got Power BI datasource with images, stored in base 64 format. I wan't to display them in paginated report.

I've tried the solution from this post but it is not working for me -->https://community.powerbi.com/t5/Report-Server/How-to-display-Base-64-PNG-images-from-a-database/m-p/1177424

Regards,

Vassil

Re: Display Images In Report Bulder using PowerBI dataset

edupuis — Mon, 14 Oct 2024 14:05:23 GMT

Hey I know this is a borderline dead thread but posting what worked for me just in case someone else needs a solution.

As we know Power Query doesn't allow for the full text of a base64 image if its characters exceed a certain size, so the dataset for images in my company has the image text split into multiple columns that are later concatenated (w the "data&colon;image/jpg;base64,") in the Desktop (that can handle full text of base64 images). This is recategorized as a Image URL and then works well in Power BI Desktop and the Service. However, Power BI Report Builder is a different animal.

I had the same problem of getting that red x and read the same forums that didn't seem to help. Eventually I just started trying #### and this specific combination worked for me:

1. Building the full base64 text as a Calculated Field without the leading "data&colon;image/jpg;base64," that I learned from the same forum you provided.

2. Using these settings for the image options:

3. And then this lookup Expression to pull the correct image based on the given parameters:

I can't promise this will work for every use case but it worked for me.