Power BI with your accounting data

BICharts - Sage 50 Accounts - Charts of Accounts

Posted by Hugh Johnson on 19-Apr-2018 15:20:58
Hugh Johnson
Find me on:

Sage 50 Accounts OData feed for Power BI

This article describes the BICharts table in the Suntico Sage 50 Accounts OData feed for Microsoft Power BI.  This table provides a list of all of your Sage 50 Charts of Accounts.

This table is essential if you want to perform profit & loss or balance sheet analysis at the nominal account (nominal code) category level for a given Chart of Accounts.

BICharts table


Column Type Description
Chart Whole Number Chart number link to BICategories
Name Text Category name e.g. "Motor Expenses"
Ref Whole Number Internal reference

BICharts relationships

The BICharts table in the OData feed is related to the BICategories table as shown below.

BICharts relationships in Sage 50 Accounts



To try our this OData feed for your Sage 50 Accounts data, why not create your own Suntico BI trial account?

Use free for 30 days 


Topics: Sage 50, Power BI Desktop, OData, chart of accounts