Retrieving G/L Account Categories table from Business Central in Power Bi

[Tris-3]

Hi,

I'm trying to pull the Account Categories Table from Business Central to infer each subcategory's parent category. Using the 'Get Data Connection', I can get the Chart of Accounts which includes the sub-category description but not the parent. I'd like to use the layout of the categories as set up in Account Categories to display the account groupings.