Dynamic 365 & Power BI - display signature(Image) from string base 64

[leed]

Hi everyone,

In SSRS, I can display Signature in CRM by using : Convert.FromBase64String(Signature.Value)

Switch to Power BI, I would like how to know to do the same thing ( means to display the "Binary" type column) ?

I use the sample "Sales Manager" of Microsoft - connect through the CRM odatafeed.

So in the picture, you see the Power Query part of the query.

What I retrieve is the "documentbody" column that contains string base 64 (text type).

I would like to display this text as an image.

Thank you in advance for your help,

Dung Anh

[v-huizhn-msft]

Hi @leed,

Like the SSAS, you import the resource table, then create a visual to display the image based on your set. In Power BI desktop, you can add the image URL, and set it as Image URL as the following screenshot.



If you get data in service, we can't set the data category. Please check if you can get data in Power BI desktop, you need to add a image URL column, and display it in Table visual. Then you peblish it to service.

Best Regards,
Angelia

[leed]

Hi @v-huizhn-msft,

Thanks for you answer.

So in Power BI Desktop, I set the column "documentbody" (which was in "text" type -string base 64 -  and "uncategorized") to "Image" categorized:

And then I upload the file to Power BI Service, but I still dont have the "documentbody" in image:

(In the picture is what I called the "string64base" text)

Thank you,

Dung Anh

[v-huizhn-msft]

Hi @leed,

If you display the image, you must have the image URL link. For example, you search a image online google, you can get the image address shown in the screenshot below.



For your "documentbody" field, it includes the image URL?

Best Regards,
Angelia

[leed]

Hi @v-huizhn-msft,

Thanks for your answer.

The documentbody does not contain URL Image. But it does contain a string base 64. To obtain an image from this I need to convert this string to an image.

For eg, in SSRS I use this function : Convert.FromBase64String(Signature.Value) to obtain this image.

Return to my question : How can we do it in Power BI Desktop? (or can we?)

Thank you,

Dung Anh

[v-huizhn-msft]

Hi @leed,

Until now, the feature is unsupported in Power BI, you can create a idea here. You also review this feature request and vote it.

Best Regards,
Angelia