Convert Binary field to readable text

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

Using NAV 2017 we are building some PowerBI reports on the NAV database. The column we need is of data-type binary. How can we convert this column back into readable text (they do contain actual text) so that we can display it in our PowerBI reports?

*This post is locked for comments

All responses (2)

Answers (0)

VINAY012 on at

Like (0)

Report

RE: Convert Binary field to readable text

e.name(formStr(DimensionDefaultingLookup));

its not working showing error

[quote user="Former Member"]
Hi,

Using NAV 2017 we are building some PowerBI reports on the NAV database. The column we need is of data-type binary. How can we convert this column back into readable text (they do contain actual text) so that we can display it in our PowerBI reports?
[/quote]
Community Member Microsoft Employee on at

Like (0)

Report

RE: Convert Binary field to readable text

Never mind, Found it already using the text.frombinary function.