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.
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
Solved! Go to Solution.
Yes, basically it was a limitation to the length of the text column. I had to break it into smaller peices.
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:
Fields:
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.
Hi @Markzolotoy can you please go into more detail about how you solved this issue? I am facing something similar
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.