Power BI with your accounting data

BICategories - Sage 50 Accounts Nominal Categories

Posted by Hugh Johnson on 19-Apr-2018 15:07:06

Sage 50 Accounts OData feed for Power BI

This article describes the BICategories table that forms part of the Suntico Sage 50 Accounts OData feed for Power BI.  This table provides a list of all of the nominal categories for each chart of accounts that you have defined in Sage 50 Accounts.

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

Read More

Topics: Reporting, Sage 50, ODBC, Accounting, Power BI Desktop, Power BI Pro, accountants, OData, power bi datasources, nominal records, nominal categories

Power BI with your accounting data

Time-saving tips, tricks, templates and tutorials

Subscribe to this blog for practical shortcuts to driving real insights from your accounting data with Power BI.


  • How-to videos
  • Example reports
  • Sample formulae
  • Data modeling tips
  • Free Power BI templates
  • Tips for optimising Sage 50cloud

Subscribe to Email Updates

Recent Posts