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
I am very happy if I can help:)
Many Thanks for the help much appreciated.
You may use
Dimensionattribute and dimensionatributevaluecombination
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Mansi Soni as our August 2025 Community…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sohaib Cheema 665 User Group Leader
Martin Dráb 595 Most Valuable Professional
Yng Lih 558
