Announcements
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
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]Never mind, Found it already using the text.frombinary function.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156