Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to display Base 64 PNG images from a database

Hello,

 

I have created a Power App which has a signature field. I want to be able to bring the signature image into the Report Builder.

 

The image is in Base64 format stored on Sharepoint. I have created a Power BI report and used this as my datasource for report builder. I successfully displayed the signature image in a Power BI table in this format but cannot bring it into the Report Builder. Here is an example of the binary image.

 

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAV4AAACWCAYAAACW5+B3AAAEyklEQVR4Xu3UwQkAAAgDMbv/0m ...

 

Settings used when inserting the image:

 

I have selected the image source as -  'Database'

 

Use this field -  '=First(Fields!Delivery_Signature.Value, "DataSet")' 

 

Use this MIME type - 'image/png.'

 

When I run the report the image is only shown as a red 'x' in the top left hand corner.

 

Any help would be greatly appreciated. Thank you

Image
report builder
  • saglamtimur's avatar
    saglamtimur
    6 years ago

    I have double check with my data. Actually you don't need to convert it. What I realized is this portion "data:image/png;base64," or similar definition is not exist in my data. May be removing this part from data will solve your problem.

     

    =Replace(First(Fields!Delivery_Signature.Value, "DataSet"),"data:image/png;base64,","")

8 Replies

  • saglamtimur's avatar
    saglamtimur
    Icon for Resolver II rankResolver II
    6 years ago

    Try converting it like;

     

    =Convert.FromBase64String(Fields!Delivery_Signature.Value)

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I used the suggested formula with an aggregate function but the image is not displaying. Is there something wrong with the formula I used?

       

      =First(Convert.FromBase64String(Fields!Delivery_Signature.Value),"DataSet")

       

       

       

      • saglamtimur's avatar
        saglamtimur
        Icon for Resolver II rankResolver II
        6 years ago

        I have double check with my data. Actually you don't need to convert it. What I realized is this portion "data:image/png;base64," or similar definition is not exist in my data. May be removing this part from data will solve your problem.

         

        =Replace(First(Fields!Delivery_Signature.Value, "DataSet"),"data:image/png;base64,","")

  • Markzolotoy's avatar
    Markzolotoy
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    Can you please provide detail about the data source you are using in your paginated report?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi, hoping this thread is till active.
    I'm trying to do this exact issue.
    That being: Trying to load an image into power bi report builder.

    In my datasouce the image is in base64 format. 
    In my report I have an image box with 'image source' set to 'database', expression: =First(Fields!binaryImage.Value, "DataSet1")

    I removed the 'data:image/png;base64,' prefix from the base64 string before it entered my datasource. 
    However the image still does not appear.
    Is there anything I'm missing here?