You’re on the Philippines site


By Odatalink
4.8 out of 5 stars
The simplest way to connect Xero with Microsoft Power BI and Microsoft Excel.


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

It’s like ODBC but for the cloud.

It enables a real-time connection from anywhere using the latest OData technology.

For managers and CFOs, this allows you to create your own KPIs and share them with stakeholders.

For accounting firms and advisers, this allows you to create your own reporting suite and market it as a point of difference.

On the 30th of June 2021, OdataLink received a Merit Award for Technology Platform of the Year from the iAwards.

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.

Reviews & ratings

4.8 out of 5 stars
20 Reviews

Sort and filter

Most recent reviews

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.
Damien Clark
Posted 7 Dec 2023
5 out of 5 stars

A great tool for Custom reporting and Data Analysis

OdataLink have enable us to report on Xero data that is not easily accessible without their tool. They provide amazing support and knowledge to backup their tool. If you want to use Power BI or Power Query (Excel) to expose more of your data, this is the tool for you.
Richard Mason
Posted 6 Dec 2023
5 out of 5 stars


Am a confirmed Xero novice, and in under 24 hours have a working model pulling live data into our group consolidated reporting (rest of group uses other software. And the support is top notch when you do need a helping hand. Cannot recommend them highly enough.

Response from OdataLink

Hi Richard, Great to hear of your positive experience and thank you for taking the time to write a review. Much appreciated

Additional info

Shared data

Quotesshared 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
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, Ireland, Malaysia, New Zealand, Philippines, Singapore, South Africa, United Kingdom, United States




Setup walkthroughContact



Get started with OdataLink

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.