How to Connect Xero to Power BI

Connecting Xero to Power BI lets you move beyond Xero's standard reports into governed, board-ready dashboards that combine finance with sales, operations and budget data. There is no native Microsoft connector for Xero, so you have three realistic routes: pull data directly from the Xero API into a custom pipeline, use a third-party connector, or have a warehouse-backed model built for you. Each has trade-offs in cost, control and maintenance, and the right choice depends on how many entities you run, how clean your chart of accounts is, and how much you care about history.

Three ways to connect Xero to Power BI

The Xero API is the most flexible option. It exposes the Accounting API (invoices, bills, contacts, the general ledger) and reporting endpoints, secured with OAuth 2.0. You can call it from Power Query, from Azure Data Factory or Fabric pipelines, or from a small script that lands data in a database. The benefit is full control over what you extract and how you model it; the cost is that someone has to own token refresh, pagination and rate limits.

A third-party connector removes most of that plumbing. Several vendors publish Xero connectors that handle authentication and incremental loads, and you point Power BI at their service or staged tables. This is the quickest route to a working dashboard, but you take on a subscription and a dependency on someone else's roadmap.

A done-for-you build lands Xero data in a warehouse you own (typically via Data Integration and Warehousing) then models it in Power BI. This is the right pattern when you consolidate multiple Xero organisations, need years of clean history, or want finance joined to non-finance sources.

If your group also reports from Sage, the guide to connect Sage to Power BI helps scope that source separately. Keep company identifiers and source-ledger checks in place before combining the figures in one finance model.

Financial KPIs worth modelling

Once the pipe is in place, the value is in the measures. Useful Xero KPIs include gross and net margin, revenue by product or tracking category, aged receivables and aged payables, days sales outstanding (DSO), cash position trend, budget versus actual, and a rolling 12-month profit and loss. A proper date dimension and a clear accrual-versus-cash decision matter more here than any clever DAX, because finance figures must reconcile to the source.

Refresh, history and the gateway

Xero's API holds plenty of history but does not surface every prior snapshot, so if you want to track how figures changed over time you must capture them yourself. That is another argument for a warehouse. For scheduled refresh, a Pro workspace allows up to eight refreshes daily and Premium or Fabric up to 48; combine that with the On-premises data gateway only if your data sits behind a private network. Watch Xero's API rate limits: aggressive refresh against a large organisation can trip throttling.

Common pitfalls

• Accounting basis mismatch. Cash versus accrual will produce different numbers from the same data. Decide once, document it, and apply it consistently.
• Multi-currency. Decide whether you report in source currency or a single reporting currency, and where conversion happens.
• Draft and deleted transactions. Filter to posted, authorised records or your totals will not tie out.
• Tracking categories. These are powerful but inconsistent if staff enter them freely; clean them at source or map them in the model.
• Token expiry. OAuth refresh tokens expire if a connection sits idle; build alerting so a silent failure does not leave the board looking at stale numbers.

Choosing the right route

If you run one tidy Xero organisation and want a dashboard this week, a third-party connector is sensible. If you consolidate several entities, need defensible history, or want finance blended with CRM and operations, invest in a warehouse-backed model. As a rough guide for UK delivery, a focused dashboard build starts from £6,000 with typical projects at £8,000–£14,000, and senior Power BI day rates run roughly £400–£850/day (as of 2026, confirm current pricing). The fastest way to de-risk the decision is a short audit of your chart of accounts and reporting needs before any build begins.

A Trusted Numbers Review reviews your Xero setup, agrees the KPI definitions and recommends the lowest-maintenance route to trustworthy financial dashboards. Book one to turn scattered Xero data into decisions you can trust.