Display Images In Report Bulder using PowerBI dataset

[Anonymous]

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...

Can you plese help with this?

Regards,

Vassil

[edupuis]

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: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: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.

[lbendlin]

"and I receive an error"

please provide more details and maybe share the error message.

[Anonymous]

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...

Regards,

Vassil