How to Connect Xero to Power BI: A Step-by-Step Guide (2026)

Xero is where your financial data lives - but its built-in reports only go so far. Connecting Xero to Power BI lets you build live dashboards, blend finance data with sales and operations, and answer questions Xero's reports can't. This guide walks through how to connect and export Xero data to Power BI, the methods that work, what a Xero Power BI dashboard can show, and the pitfalls to avoid.

Watch: a live Xero to Power BI dashboard demo built on Microsoft Fabric.

Can Power BI connect to Xero?

Yes. Power BI can pull data from Xero in three main ways: through the Xero API (using OAuth 2.0), through third-party connectors, or by routing Xero data through a data warehouse such as Microsoft Fabric. There is no single official Power BI connector that covers every scenario, so the right approach depends on your data volume and how live you need the dashboards to be.

Methods to connect Xero to Power BI

1. Xero API + OAuth 2.0 (the direct method)

Xero exposes accounting data through its API. You register a Xero developer app, authenticate with OAuth 2.0, and request data (invoices, bills, accounts, contacts). Include the offline_access scope so you receive a refresh token for long-term, unattended access - otherwise the connection breaks every time the access token expires.

2. Third-party connectors

Connectors (such as CData or similar tools) can simplify the initial connection. They are quick to start with, but can hit record limits and give you less control over history and transformations - which is why heavier or automated setups usually graduate to a warehouse.

3. The scalable approach: Xero to a data warehouse to Power BI

For anything beyond a single report, the durable pattern is to land Xero data in a governed warehouse (such as Microsoft Fabric or Azure SQL) and point Power BI at that. This gives you clean, historical, refreshable data - and lets you combine Xero with CRM, payroll and operations data in one model. It is the difference between a fragile one-off export and a real finance analytics platform. If you want the warehouse designed and built for you, that is our data warehouse consulting work.

How we build it: the secure Microsoft Fabric pipeline

Here is the exact architecture we use for clients, so the pipeline is both automated and secure:

1. Xero app + OAuth 2.0 - register a web app in the Xero developer portal, grant offline_access and accounting scopes, and complete the consent flow to get access and refresh tokens.
2. Azure Key Vault - store the Xero client ID, client secret, refresh token and tenant ID as secrets, so nothing sensitive is ever hardcoded in notebooks or code.
3. Microsoft Fabric notebook - authenticate to Key Vault, pull the secrets, and call the Xero API. An automatic token-refresh routine requests a new access token and writes the rotated refresh token back to Key Vault - so the pipeline runs unattended.
4. Bronze / Silver / Gold layers - raw Xero data lands in OneLake (Bronze), PySpark notebooks clean and standardize it (Silver), and a star-schema model is built for reporting (Gold).
5. Power BI - connect Power BI to the Gold model and build the dashboards, then schedule a refresh so everything stays current.

How to export Xero data to Power BI (step by step)

1. Register a Xero developer app and note the client ID and secret.
2. Authenticate with OAuth 2.0, including offline_access for a refresh token.
3. Discover your tenant via the Xero connections endpoint (you need the tenant ID on every request).
4. Pull the data you need - invoices, bills, bank transactions, accounts, contacts.
5. Load into Power BI (or into a warehouse first, for scale).
6. Model the data - relationships, a date table, and clean measures (revenue, margin, AR/AP aging).
7. Schedule refresh so the dashboard updates automatically.

What a Xero Power BI dashboard shows

A well-built Xero Power BI dashboard turns raw accounting data into decisions. The demo dashboards we build cover three core areas:

• Executive Financial Dashboard - total revenue, expenses, invoices, net profit and profit margin, with monthly revenue-vs-expenses and net-profit trends.
• Cash Flow Overview - cash in vs cash out, net cash flow trend, cash conversion ratio, and distribution by payment type.
• AR & AP Aging - accounts receivable and payable, collection rate, an invoice collection pipeline, aging buckets (1-30 / 31-60 / 61-90 / 90+ days) and payables by supplier.

Common errors when connecting Xero to Power BI

• Expired tokens - without offline_access and automatic refresh, the connection breaks in ~30 minutes. Store and rotate the refresh token.
• Rate limits - the Xero API caps calls per minute/day; a warehouse buffer avoids hammering the API on every report open.
• Credentials in code - hardcoding client secrets is a security risk. Use a secret store like Azure Key Vault.
• No history - the API shows current state; a warehouse preserves historical snapshots for trend analysis.

Why work with a Xero + Power BI specialist

A working connection is easy; a trustworthy, scalable, secure one is not. Through our Power BI consulting we help finance teams build Xero to Power BI reporting that is automated, accurate and built to grow - from a single dashboard to a full finance analytics platform on Microsoft Fabric.

Frequently asked questions

Can Power BI connect to Xero?

Yes. Power BI can connect to Xero through the Xero API (using OAuth 2.0), through third-party connectors, or by routing Xero data through a data warehouse such as Microsoft Fabric. The warehouse approach is the most reliable for automated, always-current dashboards.

How do I export Xero data to Power BI?

Register a Xero developer app, authenticate with OAuth 2.0 (with offline access for a refresh token), pull the data you need from the Xero API, land it in Power BI or a warehouse, model it, and schedule a refresh so dashboards stay current. Storing credentials in a secret store like Azure Key Vault keeps the pipeline secure.

Is there a direct Xero connector for Power BI?

There are third-party connectors for Xero, but no single official Power BI connector covers every scenario. For larger or automated setups, ingesting Xero data through the API into a data warehouse first is more reliable and scalable.

What can a Xero Power BI dashboard show?

A Xero Power BI dashboard can show revenue vs expenses, net profit and margin, cash flow (cash in vs cash out), accounts receivable and payable aging, collection rates, and KPI trends over time - all refreshed automatically from your Xero organization.

How do I keep Xero Power BI dashboards up to date?

Use scheduled refresh in Power BI. For robust automation, land Xero data in a warehouse on a schedule with automatic OAuth token refresh, and have Power BI read from there - this avoids expired tokens and API limits.