How to configure G/L Account Categories?

Prerequisite: Please make sure you have installed the Power BI Insights Connector App. 

In Dynamics 365 Business Central search for G/L Account Categories. 


Here you can create new categories and/or rename existing ones.

In the G/L Account Categories screen, you will find two extra fields: Account Subcategory (Power BI) and Account Subcategory 2 (Power BI). For each G/L Account Category please select the appropriate Account Subcategory (Power BI) and also Account Subcategory 2 (Power BI) where required.


These two fancy fields will be used by Power BI to calculate financial ratios and KPIs (and some other smacking ratios that would make any accountant a little steamy under the collar 😉) including efficiency, debt, leverage, liquidity and profitability ratios. 

You need to make sure that all your G/L Accounts are classified correctly into groups.


If you haven’t fallen asleep, you should be ready to create some of the most beautiful finance reports around.

You can find more information about Account Categories here.