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

Sage 50 Accounts as a data source for Power BI

Posted by Hugh Johnson on 17-Apr-2018 10:59:08

Add Sage 50 Accounts to your list of Power BI data sources

The Suntico BI OData feed turns your Sage 50 Accounts system into an online business intelligence data source for tools like Microsoft Power BI.  It delivers the following data tables:

  1. BICategories - definining your nominal code categories for each chart of accounts
  2. BICharts - your charts of accounts listing
  3. BICountries - your Sage 50 countries table enriched 
  4. BICurrencies - your customer currencies
  5. BICustomers - your customer records
  6. BIDepartments - your Sage 50 department list
  7. BIMetaData - data about your Sage 50 dataset
  8. BINominalBudgets - your nominal code budgets for the current financial year
  9. BINominalRecords - your nominal account records
  10. BIPeriods - deinitions of your financial year
  11. BIProductSales - sales details from your customer invoices
  12. BIPurchaseOrderLines - purchase order line items
  13. BIPurchaseOrders - your Sage 50 supplier purchase orders
  14. BISalesOrderLines - Sales Order line items
  15. BISalesOrders your Sage 50 customer sales orders
  16. BIStocks - your products and services
  17. BISupplierCurrencies - your supplier currencies
  18. BISuppliers - your supplier records
  19. BITransSplits - your full transaction audit trail
Read More

Topics: Sage 50, Power BI, Sage 50cloud, Power BI Desktop, Power BI Pro, OData, power bi datasources

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