Blank amount from Business Central datamodel in Power BI

[MIchri]

Hi,

I have build the Business Central datamodel in Power BI and want to look at the amount from G_LEntries table split on month from my calender table. 

However it returns a blank value:

When I add "No" from CS_GLAcoounts table it is possible:

My datamodel using "No" from  CS_GLAccounts and "G_L_Account_Name" from G_LEntries as key

Can you help? 

Best regards,

Mikkel

[tex628]

From what i can tell the total sum of all transactions across your accounts is 0. 

If you scroll down in your second table with the account breakdown, what is the grand total showing you per month? 

Br,
J

[MIchri · Accepted solution]

HI @tex628 

Yes, you're right! I have set my amount values to "sum" instead of "dont summarize". Embassasing but thanks anyhow 🙂 

[tex628]

Ahhh well good to hear it worked out! 🙂