Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Display Images In Report Bulder using PowerBI dataset

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

 

 

images
Report Builders
Report Data
SSRS

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    "and I receive an error"

     

    please provide more details and maybe share the error message.

  • edupuis's avatar
    edupuis
    Advocate I
    1 year ago

    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.