Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
Hello,
once I have converted the blob into readable text in Navision, can I read or display it in Power BI?
Kind 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |