Power BI really shines when you give it relational data to work with - tables, relationships and enough history to spot a trend. Unfortunately, querying the Sage Accounting API directly from Power BI is slow, fragile and quickly runs into rate limits. The better approach is to stage your Sage Accounting data in a database first, then let Power BI do what it does best: interactive dashboards, drill-downs and combining Sage Accounting with the other systems your business runs on.
In this article, I’ll take you through the steps to connect Power BI to your Sage Accounting data, and get started customizing the reports you need.
Connect to Sage Accounting
If you don’t already have a SyncHub account, you can grab a free trial here - go on, I’ll wait - it only takes a minute and you can cancel as soon as you’ve finished this tutorial if you like.
Ready? Now, a quick reminder - SyncHub works by staging your Sage Accounting data in a relational database. This gives us a huge advantage over other connectors which query the Sage Accounting API directly, but I won’t go in to them here. The point is, once you have connected your Sage Accounting account, querying from Power BI is trivial as you are just using its native SQL Server Connector.
Once connected, you'll find data from all these endpoints streaming down from Sage Accounting, such as this example from the SalesInvoice table:
| DueDate | Editable | TaxAmount | TotalAmount | TotalPaid | ContactID |
|---|---|---|---|---|---|
| 2026-02-02 00:00:00 | true | 10.00 | 100.00 | 0.00 | 100 |
| 2026-03-01 00:00:00 | true | 15.00 | 150.00 | 0.00 | 455 |
| 2026-03-01 00:00:00 | true | 15.00 | 150.00 | 50.00 | 53 |
After connecting, visit your SyncHub Dashboard and grab your new database credentials - you'll need them below.
Reading your Sage Accounting data from Power BI
We now just need to tell Power BI where to find your data. Either select Import data from SQL Server or a new SQL Server connection from the Data ribbon:
When prompted, enter the Server and Database that SyncHub provided in the first step above:
Next - and this is the part that trips most people up - switch to the Database credentials tab (highlighted by the arrow below), then enter the username and password provided to you by SyncHub in the step above:
Troubleshooting
This is the point where you are most likely to run into issues - your login won’t be accepted. After triple-checking that you have used the correct server/database/username/password, the most common resolutions we see are:
- try opening Power BI in Administrator mode
- if you are in an office, perhaps you have some firewall restrictions?
All going well, you’ll now be presented with the tables from Sage Accounting, and you know what to do from here:
Keeping your data up-to-date
SyncHub updates it’s staged data from Sage Accounting in near-realtime, so it’s always available. However, depending on your Power BI settings you may still observe a delay with your reports. But not to worry - the solution isn’t too onerous. Every time you want to refresh your data, simply click the (appropriately named) Refresh button in your Ribbon:
Beyond Sage Accounting
Sage Accounting-specific reports are essential, but the true power of SyncHub comes when you augment your Sage Accounting data with additional information:
- SyncHub allows you to pull in data from multiple Sage Accounting accounts, and compare/report/aggregate from within the same report. See this blog article for details on aggregating your Sage Accounting data.
- Most businesses use multiple cloud platforms. SyncHub provides connectors to a wide range of popular cloud platforms. Imagine the insights you could gather by consolidating this information into a single dashboard (or see this case study for real-world examples).
So what are you waiting for? Grab a free trial of SyncHub here and see what you can do. In ten minutes from now, you could be reporting against your Sage Accounting data and taking your first steps towards a data-driven business.