You’re on the United States site
Select a region


By Odatalink
4.82 out of 5 stars
Free trial available
Get this app
The simplest way to connect and consolidate Xero data with Power BI and Excel.
out of 5
Reviewed by
Xero users
Try this app
Free trial
Key functions
Accountant tools


OdataLink is a secure cloud service for Power BI and Excel users to create online dashboards and reports using live Xero data.

It enables a real-time connection to your Xero data from anywhere using the latest OData technology.

OdataLink provides access to over 70 data points allowing you to build reports ranging from Profit and Loss, Balance Sheet, Cash Flow, Sales, Inventory or Payroll.

OdataLink is entirely cloud-based and works without the need to install any software or configure complex gateways.

Finally, we pride ourselves in providing the best possible support. Our staff are experts when it comes to answering any questions you have whether about Xero's data, Power BI, Power Query and Excel.


  • Managers or CFO wanting to track KPIs and share them with stakeholders.
  • Accounting Firms, Power BI developers and Consulants needing to create reports for their customers.
Play Video
, opens in a dialog

OdataLink + Xero

OdataLink allows you to create a live read-only connection to your Xero data in the form of an OData data feed.

It utilises the existing standard OData connector available in Power BI, Excel, SQL Server (SSIS) and Tableau and removes the need to install any additional software.

Any transformation instructions such as filtering and sorting is passed directly Xero creating seamless, agile, responsive and fast experience.

With all the data in your hands, you now have easy access to a wealth of reporting platforms which were previously out of reach.

COMPATIBLE WITH: OdataLink can be used with a number of different technologies including:

  • Microsoft Power BI
  • Microsoft Excel
  • Tableau
  • Azure Data Factory and SSIS
  • Microsoft Fabric

Reviews & ratings

4.8 out of 5 stars
22 Reviews

Sort and filter


Most recent reviews

Melissa Lee
Posted 18 Jul 2024
5 out of 5 stars

Amazing product and customer support

Such a great tool to pull data from Xero into PowerBI automatically with ease! Fantastic product and incredible customer support. The ODataLink team are experts, super responsive, and really care about helping their customers. Thank you!!
Tom Grant
Posted 12 Jan 2024
5 out of 5 stars

Great way to export all data from excel

Previously used a well known 3rd party app to do the same thing, however due to the api limits for 3rd party apps pulling invoices and payments would fail after a couple of attempts due to exceeding API limits - as this is an authorised app we do not have the same issues! It doesn't have quite as many tables available from xero like invoice change logs etc which would be useful but it was too much data for a third party app that had them available. Great if you want to report and manipulate data in excel and power BI as we found getting information out of xero to be one of Xero's biggest downside but this overcomes that issue
One person found this review helpful.
Nico Lessing
Posted 8 Dec 2023
5 out of 5 stars

Assistance to understand the integration between Xero and OdataLink

Odatalink is very helpful in assisting with any problems I encounter with my setup.

Additional info

Shared data

Quotesshared from Xero to OdataLink
Budgetsshared from Xero to OdataLink
Timesheetsshared from Xero to OdataLink
PayRunsshared from Xero to OdataLink
PayItemsshared from Xero to OdataLink
Accountsshared from Xero to OdataLink
Overpaymentsshared from Xero to OdataLink
Payment Servicesshared from Xero to OdataLink
Usersshared from Xero to OdataLink
Tracking Categoriesshared from Xero to OdataLink
Tax Ratesshared from Xero to OdataLink
Reportsshared from Xero to OdataLink
Receiptsshared from Xero to OdataLink
Purchase Ordersshared from Xero to OdataLink
Prepaymentsshared from Xero to OdataLink
Paymentsshared from Xero to OdataLink
Manual Journalsshared from Xero to OdataLink
Linked Transactionsshared from Xero to OdataLink
Journalsshared from Xero to OdataLink
Itemsshared from Xero to OdataLink
Invoicesshared from Xero to OdataLink
Employeesshared from Xero to OdataLink
Currenciesshared from Xero to OdataLink
Credit Notesshared from Xero to OdataLink
Contactsshared from Xero to OdataLink
Branding Themesshared from Xero to OdataLink
Bank Transfersshared from Xero to OdataLink
Bank Transactionsshared from Xero to OdataLink


Accountant toolsReporting


Professional servicesAccounting

App details

By Odatalink


Australia, Canada, Global, Hong Kong, Indonesia, Ireland, Malaysia, New Zealand, Philippines, Singapore, South Africa, United Kingdom, United States




Setup walkthroughContact



Try OdataLink for free

Although Xero reviews each app in the Xero App Store, we can’t give any guarantees. It’s up to you to assess the performance, quality and suitability of any app before going ahead.