topic Re: How to display Base 64 PNG images from a database in Report Server

How to display Base 64 PNG images from a database

Anonymous — Tue, 23 Jun 2020 19:41:02 GMT

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&colon;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

Re: How to display Base 64 PNG images from a database

saglamtimur — Wed, 24 Jun 2020 07:29:35 GMT

Try converting it like;

=Convert.FromBase64String(Fields!Delivery_Signature.Value)

Re: How to display Base 64 PNG images from a database

Anonymous — Wed, 24 Jun 2020 08:57:52 GMT

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

Re: How to display Base 64 PNG images from a database

saglamtimur — Wed, 24 Jun 2020 09:14:39 GMT

I have double check with my data. Actually you don't need to convert it. What I realized is this portion "data&colon;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&colon;image/png;base64,","")

Re: How to display Base 64 PNG images from a database

Anonymous — Wed, 24 Jun 2020 09:49:01 GMT

I removed the prefix 'data&colon;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.

Re: How to display Base 64 PNG images from a database

Markzolotoy — Wed, 27 Jan 2021 16:36:23 GMT

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

Re: How to display Base 64 PNG images from a database

Anonymous — Thu, 27 Oct 2022 12:30:14 GMT

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&colon;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?

Re: How to display Base 64 PNG images from a database

AshutoshSahoo_1 — Fri, 18 Nov 2022 05:33:53 GMT

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

Re: How to display Base 64 PNG images from a database

GS30 — Wed, 25 Sep 2024 01:46:20 GMT

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

thanks