Reading a blob from Navision Record Link

[Chris_23]

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

[v-juanli-msft · Accepted solution]

Hi @Chris_23 

First please convert the value in blob field into readable text.

https://community.dynamics.com/nav/b/navisiontechnicalkulla/posts/how-to-read-write-notes-in-navisio...

Or

https://thinkaboutit.be/2019/03/how-do-i-use-record-notes-in-an-al-page-or-report/

Best Regards

Maggie

[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

[v-juanli-msft · Accepted solution]

Hi @Chris_23 

First please convert the value in blob field into readable text.

https://community.dynamics.com/nav/b/navisiontechnicalkulla/posts/how-to-read-write-notes-in-navisio...

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 · Accepted solution]

Hi @Chris_23 

I'm afraid so.

Best Regards

Maggie