Announcements
No record found.
Hi,
I am working on a financial report in Power BI using a Data Lake export from D365F&O. In the General Journal Account Entry table, I have two fields "LedgerAccount" and "LedgerDimension". From looking at the data via a different source other than the data lake, I need the "LedgerDimension" field. However in the data I get a sort of RecId number rather than the list of the dimensions separated by a hyphen which I would expect, and I get this on the "LedgerAccount" field. Is there another table that I need to link to that RecId number I have in my LedgerDimension field to get the correct data.
Hope you can help.
Many Thanks
You may use
Dimensionattribute and dimensionatributevaluecombination
Many Thanks for the help much appreciated.
I am very happy if I can help:)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 429 Most Valuable Professional
CU10121822-0 366
André Arnaud de Cal... 360 Super User 2026 Season 2
