Power BI

Connect Power BI to Sage 50 Accounts - Part 4 of 4

Reporting, Connect Power BI to Sage 50, Sage 50, Power BI, ODBC, Sage 50cloud, Accounting

Francisc Furdui @12/9/2018 11:06:44 AM

Connect Power BI to Sage 50 Accounts - Part 4 of 4


Connect Power BI to Sage 50 Accounts via Suntico. How to connect your Sage 50 data to Power BI Pro and Power BI Desktop. Free Power BI Desktop Template will save you weeks.


Connect Power BI to your Sage 50 OData Feed

This blog describes part four of a four-part process to connect Power BI to Sage 50 using the Suntico BI service.  In this blog I show you how to link your Sage 50 company (or companies) that you have in your Suntico account to Microsoft Power BI.  We will look at two examples:

  1. Connecting your Sage 50 company to the "Accounting Insights for Sage 50" Content Pack on the Power BI Service.
  2. Connecting your Sage 50 company to Power BI Desktop.

You can do either or both.  Maybe it is a good idea to connect to the Content Pack first, as that will give you a ready-made dashboard and report that you can start to use right away.  Meanwhile, you can connect to Power BI Desktop and start to build out some custom reports is you alsow wish to.  To get you started with Power BI Desktop you can also download a Power BI Template file that will save you a lot of work setting up your Sage 50 model.

Let's start with the common activity that you will nee to do, and that is to generate your Power BI keys (username and password) for the Suntico BI OData feed.


Power BI

BIDates - Power BI Dates Table for Sage 50 Accounts

ODBC, Power BI Desktop, OData

Hugh Johnson @7/28/2018 3:22:00 PM

BIDates - Power BI Dates Table for Sage 50 Accounts


Description of the BIDates table in the Suntico Sage 50 Accounts OData feed for Power BI. This is a preconfigured Power BI Dates Table for Sage 50 Accounts that provides the link between date-driven transactions and has built-in intelligence relating to the accounting year . Why not try it now?


Sage 50 Accounts OData feed for Power BI

This article describes the BIDates table in the Suntico Sage 50 Accounts OData feed that you have set to as one of your Power BI data sources.  

This table is essential if you want to analyse your various Sage 50 Accounts data tables by date or period.


Power BI

BISalesOrderLines - Sage 50 Accounts Sales Order Lines table

ODBC, Power BI Desktop, OData, sales orders

Hugh Johnson @4/18/2018 9:29:25 PM

BISalesOrderLines - Sage 50 Accounts Sales Order Lines table


Here are the BISalesOrderLines table details in the Suntico Sage 50 Accounts OData feed for Power BI. This table contains the Sage 50 Accounts Sales Order Lines - is the line item information for all of your Sales Orders and Quotes in your Sage 50 SOP module. Why not try it now?


Sage 50 Accounts OData feed for Power BI

This article describes the BISalesOrderLines table in the Suntico Sage 50 Accounts OData feed for the Power BI Sage 50 Accounts integration.  This table is derived from the underlying Sage 50 Accounts SOP_ITEM ODBC table. 

This table is essential if you want to analyse your Sage 50 Sales Orders at the product line item level.


Power BI

BISalesOrders - Sage 50 Accounts Sales Orders table

ODBC, Power BI Desktop, OData, sales orders, Sage 50 Accounts

Hugh Johnson @4/18/2018 9:11:17 PM

BISalesOrders - Sage 50 Accounts Sales Orders table


Details of the BISalesOrders table in the Suntico Sage 50 Accounts OData feed for Power BI. This table is the header information for all of your Sage 50 Accounts Sales Orders and Quotes from your Sage 50 SOP module. Why not try it now?


Sage 50 Accounts OData feed for Power BI

The Suntico BI OData feed turns your Sage 50 Accounts system into an online business intelligence data source for tools like Microsoft Power BI.  This article describes the BISalesOrders table.  This table is derived from a number of underlying Sage 50 Accounts SALES_ORDER ODBC table. 

This table is essential if you want to analyse your Sage 50 Sales Orders.


Power BI

BIProductSales - Sage 50 Accounts Sales Invoices table

ODBC, Power BI Desktop, OData, sales invoices, product sales, sales orders

Hugh Johnson @4/18/2018 5:28:56 PM

BIProductSales - Sage 50 Accounts Sales Invoices table


Sage 50 Accounts Sales Invoices data with the sales invoice headers, line item details, historic line item margin, delivery address. Everything you need to analyse your product sales in Power BI. Why not try it now?


Sage 50 Accounts OData feed for Power BI

This article describes the BIProductSales table in the Suntico Sage 50 Accounts OData feed in the Suntico Power BI Sage 50 Accounts integration.  This table is derived from a number of underlying Sage 50 Accounts ODBC tables and provides details of all of the sales transactions created through the Sales Orders or Invoices & Credits modules in Sage 50.  It is essentially Sage 50 Accounts Sales Invoices with all the line item information and some further enrichments, for example to include gross margin of a transaction line item.

This table is essential if you want to analyse sales and margin by product code over time.


Power BI

BICustomers - Sage 50 Accounts Customer Records

Sage 50, ODBC, Power BI Desktop, OData, customers, sales ledger

Hugh Johnson @4/17/2018 3:11:36 PM

BICustomers - Sage 50 Accounts Customer Records


Details about the BICustomers table in the Suntico BI data feed for Power BI. Use this to add customer reference information into your analysis such as currency, country, average time to pay, credit limit, balance, due days etc.. Why not try it now?


Sage 50 Accounts OData feed for Power BI

This article describes the BICustomers table that forms part of the Suntico Sage 50 Accounts OData feed for Microsoft Power BI.  Use this table to add any customer reference information to your reports.  


Power BI

BITransSplits - Sage 50 Accounts Audit Header & Transaction Splits

ODBC, Power BI Desktop, OData, Transaction Splits

Hugh Johnson @4/17/2018 11:39:19 AM

BITransSplits - Sage 50 Accounts Audit Header & Transaction Splits


Details about the BITransSplits table in the Suntico Sage 50 Accounts OData feed for Power BI. Use this table for accounts receivable and payable analysis, profit & loss, balance sheet, budgets, purchase invoice and departmental analsysis. Why not try it now?


Sage 50 Accounts OData feed for Power BI

This article describes the BITransSplits table in the Suntico Sage 50 Accounts OData feed for tools like Microsoft Power BI.  The table is a flattened combnation of the Sage 50 Accounts ODBC tables AUDIT_HEADER and TRANS_SPLITS.

This table provides all of the transaction splits of of all of your posted Sage 50 Accounts transactions going back over the last c. 800 days.  Excluded are any deleted transactions.

This table is essential if you want to analyse any of the following Sage 50 Accounts data:

  • Accounts payable
  • Accounts receivable
  • Nominal transactions
  • Purchase Invoices
  • Departmental Profit & Loss
  • Imported Sales transactions (via CSV)*
  • Sales transactions created via the Batch Input screens in Sage 50 Accounts*

*Sales transactions that are imported into Sage 50 Accounts via CSV file, or created through the Batch Invoices screen go straight to the Transactions audit log and do not appear in the Sage 50 Accounts Invoices list.


Power BI

How to update your Suntico BI Connector software

Reporting, Connect Power BI to Sage 50, Sage 50, Power BI, ODBC, Sage 50cloud, Accounting

Hugh Johnson @4/11/2018 7:42:01 AM

How to update your Suntico BI Connector software


The Suntico BI Connector software is designed to receive updates automatically, but to avoid interruptions to your Sage 50 server you have a lot of flexibility over when or if these auto-updates happen. This article describes your options.


Auto-update or update now

This blog describes how to update your Suntico BI connector when there is a new version available. 


  • 1-10

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

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

+353 1 567 4069