GL Accounts & GL Entry Relationship - PowerBI

stunomatic

I am trying to create a trial balance sheet using PowerBI. (not using content pack as it is not available for NAV2009).


In NAV Chart of Accounts there are Head Accounts and Sub-Accounts.

IN SQL DATABASE Tables
- GL_Accounts. (All Acc. numbers are listed).
- GL Entry. (Only Sub Account numbers are listed because entries are done in sub accounts).


Using relationship 1 to many "GL_Account No"


Now using PowerBI I only want to show Trial Balance of Head Accounts and for sub accounts I will use drill down methods BUT I cannot find relation within GL_Entry for head accounts.

In GL_Account table there is one column Totaling in which range of sub accounts is define.






Even if I use fill down this won't create any relation with GL_Entry.


I hope I make sense

Thanks