Address
8-9 Marino Mart, Fairview, Dublin 3, D03 EK81, Ireland
Contact
contact@accountinginsights.co.uk
Sage 50 Power BI Connection depends on what Sage 50 edition you have
Sage 50 is a brand name given to different accounting products. The best way to connect to Sage 50 with Power BI, depends on whether you are using Sage 50 Accounts (UK/Ireland), Sage 50 Accounting (Canadian Edition) or Sage 50 Accounting (US Edition)
Sage 50 Accounts (UK/Ireland)
We recommend using a 64-bit ODBC connection with the Microsoft Data Gateway to connect from the Power BI Service.
Sage 50 Accounting (Canadian Edition)
It is possible to set up an automated connection via ODBC from Power BI to Sage 50 Accounting (Canadian Edition) without a dedicated connector.
Sage 50 Accounting (US Edition)
You cannot connect to Sage 50 Accounting (US Edition) and Power BI Desktop because of the mismatch between the 32-bit and 64-bit architectures of the two products. To resolve this, we can offer a connector that will synch your Sage 50 Accounting (US Edition) tables to a SQL Azure database. Contact us for more details.
Sage 50 Power BI Connection Options
Sage 50 Accounts
For Sage 50 Accounts, we always recommend connecting Power BI using ODBC. It can provide a fast and reliable method to access all of your Sage 50 Accounts tables. If you set it up correctly, it is simple to maintain as you move from one version of Sage 50 Accounts to another, without the need to modify your reports. There are broadly four ways to set up such a Sage 50 Power BI connection.
- An ODBC connection from your Power BI report to Sage 50. In this case, your Power BI report will need to have direct network access to your Sage 50 Accounts data, or indirect access via the Microsoft Data Gateway.
- An ODBC connection from a Dataflow to Sage 50 (via the Microsoft Data Gateway), and then connect your Power bi report(s) to the Dataflow(s).
- We can offer a connector to use ODBC to connect to Sage 50 and populate a SQL database as part of an enterprise data warehouse solution.
- A hybrid of the three methods above.
Sage 50 Accounting (Canadian Edition)
Sage 50 Accounting (Canadian Edition) is a 32-bit application. This means that you cannot by default connect to it with Power BI, which is a 64-bit application.
To resolve this issue, we can provide a connector to poll the Sage 50 tables using ODBC and synchronise them to an Azure SQL database.
Alternatively, we can assist with upgrading your Sage 50 Accounting ODBC driver to support a 64-bit connection.
Sage 50 Accounting (US Edition)
Sage 50 Accounting (US Edition) is a 32-bit application. In August 2025, Microsoft deprecated the 32-bit version of Power BI Desktop. Unless you have an old 32-bit version of Power BI Desktop, you will not be able to connect directly to Sage 50 Accounting (US Edition) from Power BI.
To resolve this issue, we can provide a connector to poll the Sage 50 tables using ODBC and synchronise them to an Azure SQL database.
A single set-up fee plus database costs (the database can be hosted by us or set up in your environment).
Resources
Reports example pages
Playlist
3 Videos
