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 ha...
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,","")

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,","")

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I removed the prefix 'data:image/png;base64,' from the Power BI Datasource and it is working.

     

    I presume the option choose 'MIME type' reomves the need for the prefix in the binary image where Power BI will automatically select the image type.

     

    Thanks for the help.

    • GS30's avatar
      GS30
      Frequent Visitor
      2 years ago

      can you please explain how did you fix the this issue as I am struggling to fix it.

      thanks

  • AshutoshSahoo_1's avatar
    AshutoshSahoo_1
    Frequent Visitor
    3 years ago

    Hi ,

    I removed the prefix from the data and in the database my particular column in LongBLOB data type and after  using the Replace DAX which one you gave this error is coming .

     

     

    "The 'Value' expression for the image 'Image3' contains an error: [BC30455] Argument not specified for parameter 'Find' of 'Public Function Replace(Expression As String, Find As String, Replacement As String, [Start As Integer = 1], [Count As Integer = -1], [Compare As Microsoft.VisualBasic.CompareMethod = Microsoft.VisualBasic.CompareMethod.Binary]) As String'.
    ----------------------------
    The definition of the report '' is invalid."

     

    Can you please Help me in this 

     

    Thanks & Regards

    Ashutosh Sahoo