Creating non-agregated reports with Power BI (using GeneralLedgerActivites)

(0) Share

Report

Posted on by Community Member

Hi All

I am looking to create a small Power BI data model which can be used for small scall reporting of Finance and operations data.
The primary goal is to look the main accounts and find the ledger activity.

I have created a data model that looks like this, but the GeneralLedgerActivites table seem to be agregated or simply not showing the "LedgerRecID"
Is there any way to include this?

I originally wanted to import the GeneralJournalAccountEntry table, but that seems to not be there? perhaps a view table from F&O? Or can it be exposed, and would it actually solve my issue?.

Ideally the users needs to look up an account and see the individual ledger lines.

This is the data model in Power BI currenly:

3480.data-model.png

Help or directions would be appreciated

/Daniel