Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Markzolotoy
Impactful Individual
Impactful Individual

Problem showing image in paginated report

I have an image object in both paginated report and a ssrs report. Both images are bound to a field from a dataset. Both datasets show the same Base64 string. =Convert.FromBase64String(First(Fields!body.Value, "DataSet1")) works fine on ssrs report, but in paginated report it is the red X. the only difference is that ssrs report uses embedded connection string and paginated report uses PBI dataset. I also have a text field in the paginated report that shows correct Base64 string. Any idea what's wrong?

 

Thanks

1 ACCEPTED SOLUTION

Yes, basically it was a limitation to the length of the text column. I had to break it into smaller peices.

 

View solution in original post

5 REPLIES 5
Markzolotoy
Impactful Individual
Impactful Individual

I have a paginated report that uses PBI dataset for its data source. The data source looks like this:

Web{"url":"http://computername:8090/endpointname"}Maps to: New data source 2

 

In PBI service the dataset name is DS_HighchartExport.

 

Here how it looks in report:

 

 

 

DataSet1:

Capture.PNG

Fields:

Capture.PNG

In report a dataset based on that data source produces correct data. The data is a Base64 string. It is bound to an image in the report like this:

=Convert.FromBase64String(First(Fields!body_1.Value, "DataSet1"))

I also tried:

=Convert.FromBase64String(First(Fields!body.Value, "DataSet1"))

 

Same thing: Red X. 

 

The same data with the same image object in SSRS report works fine.

 

Please help.

 

Thanks

Hi, @Markzolotoy 

Could you please tell me whether your problem has been solved?
For now, there is no content of description in the thread. If you still need help, please share more details to us.

Best Regards,
Community Support Team _ Eason

Yes, basically it was a limitation to the length of the text column. I had to break it into smaller peices.

 

Anonymous
Not applicable

Hi @Markzolotoy  can you please go into more detail about how you solved this issue? I am facing something similar

v-easonf-msft
Community Support
Community Support

Hi , @Markzolotoy 

After searching, I found an article on a similar topic, you can check whether the solution in the thread is also applicable to you.

ssrs-show-base64-string-or-byte-array-from-url-as-image 

 

Best Regards,
Community Support Team _ Eason

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.