Sage 50 Accounts as one of your Power BI data sources

by Hugh Johnson, Posted on 4/13/2018 6:28:08 AM

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

Sage 50 Accounts as one of your Power BI data sources

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 Accounts countries table enriched 
  4. BICurrencies - your customer currencies
  5. BICustomers - records of your Sage 50 Accounts customers
  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

How you can use the OData feed

You can use the Suntico BI OData feed for Sage 50 Accounts just as you would use any OData source in Power BI.   You can use it as a data source for Power BI Desktop as well as a data source for Power BI Pro on the web.

This means that if you author a report in Power BI Desktop and publish to the web, then you can schedule an automated refresh of your dashboard and reports every day.

Why not give a try today and create your own Suntico BI Trial Account?



Copyright © 2019,
Accounting Insights Ltd.
All Rights Reserved.

Our Office :
Unit 4, Roof Garden Offices,
Clarehall Shopping Centre,

+353 1 567 4069

[email protected]