What changes and when
Custom Connections are a paid Xero option for a background integration that accesses a single organisation. They let an app request access tokens with its own credentials. Xero sets the following dates for new apps and unused subscriptions.
| Date | What changes |
|---|---|
| 1 December 2026 | Xero closes new Custom Connection app creation and subscription sales. Apps created before the cutoff retain their current API access and daily call limit. After the cutoff, deleting an app or cancelling a subscription removes the option to recreate or repurchase it. |
| 15 February 2027 | Last day to attach an unused subscription to an existing Custom Connection app or cancel it yourself. |
| 16 February 2027 | Xero cancels subscriptions that are still unused. |
Read Xero’s Custom Connections FAQ.
To check your setup, open the relevant organisation in Xero and go to Settings → Connected apps → App Store subscriptions → Custom Connections. Keep an existing working connection in service while you test a new reporting workflow.
Xero’s Accounting API and standard app authorisation continue. Microsoft’s separate Power BI Xero content pack deprecation dates to 2019. Xero report exports, managed connectors and custom API integrations are also available.
Set up Xero reporting with Datplan DataPull
DataPull uses Xero’s standard app authorisation and pulls supported records and reports into your Windows environment. It prepares related reporting tables for finance totals, invoices, invoice lines and payments. You choose where to save the exports and can reuse those files each month.
- Connect your Xero organisation. In DataPull on Windows, select your workspace and Xero as the source. Approve access in Xero and choose the organisation you want to report on.
- Run the pull and export the prepared tables. Check that the pull completed and export the Basic BI package to a dedicated folder for the organisation. Start with Financial Summary for finance totals and add invoice or payment tables as the report requires.
- Load the data in Excel or Power BI. Point Power Query at the prepared files. Supported Power BI exports can include a starter project with table relationships and measures. For a ready-made report, you can also use DataPull’s Xero browser dashboards.
- Repeat the refresh. Run the next pull and export to the same folder, then refresh Excel or Power BI. On plans with scheduling, DataPull can run the pull and export while the Windows PC, session and Xero connection are available.
Try the workflow with sample data in the free Windows app. Connecting live Xero data uses a paid Datplan plan. See the Xero data and reports DataPull prepares.
Move a Power BI report to DataPull
- Save your Xero figures for comparison. Pick one organisation and one closed month. Save its Trial Balance and P&L with the same period, accounting basis, currency and tracking scope as your report.
- Repoint a copy of the model. Use the DataPull export for that organisation. In Power Query, update the file or folder source and match the new columns and keys to the existing model before refreshing.
- Check the figures and the next refresh. Compare Trial Balance accounts and P&L totals to Xero. Run another DataPull extraction and check that both the export and report refresh completed. If you publish in Power BI Service, configure access to the files and verify its refresh history. Microsoft’s refresh guidance.
| Control | Xero control report | Refreshed Power BI copy |
|---|---|---|
| October revenue | £48,000 | £48,000 |
| October net profit | £8,250 | £8,250 |
| Trade receivables at 31 October | £12,600 debit | £12,600 debit |
| VAT control at 31 October | £3,200 credit | £3,200 credit |
Use your own Xero reports for sign-off. If a balance differs, start with the date filters, account mapping and debit or credit signs. See Datplan DataPull’s Xero-to-Power-BI workflow.