Forum Discussion
Display Images In Report Bulder using PowerBI dataset
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.