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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors