Forum Discussion
Helper IIReading a blob from Navision Record Link
Hello guys,
I would like to read the notes from Navision, which are stored in the system table Record Link.
With the target I load the Record table into Power BI Desktp.
The actual note is stored as BLOB in the column "Note" and the link to the record is stored as URL in the column "URL1".
Is there a way to make the note visible in Power BI?
Best Regards
Chris
Hi Chris_23
First please convert the value in blob field into readable text.
Or
https://thinkaboutit.be/2019/03/how-do-i-use-record-notes-in-an-al-page-or-report/
Best Regards
Maggie
4 Replies
v-juanli-msftCommunity Support
Hi Chris_23
First please convert the value in blob field into readable text.
Or
https://thinkaboutit.be/2019/03/how-do-i-use-record-notes-in-an-al-page-or-report/
Best Regards
Maggie
- Chris_23
Hi v-juanli-msft ,
thank you very much for your answer.
So the way I see it, I have to do the conversion in Navision myself and I can't do it in PowerBI directly?
Best Regards
Chris
- v-juanli-msft
- Chris_23
Hello,
once I have converted the blob into readable text in Navision, can I read or display it in Power BI?
Kind regards
Chris
