You’re on the Canada site
  1. Home
  2. Featured apps


By Odatalink
4.76 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
17 Reviews

Sort and filter

Most recent reviews

Jane Donnithorne
Posted 18 Sep 2023
5 out of 5 stars

Phenomenal Service and Support

Nic and Jeff are the most amazing team, I can’t speak highly enough of how good their service and support is. I’ve been able to ditch expensive software and consultants and use my intermediate skills to present a model for our business which is exceptional. It’s so relaxing to know that when/if I get stuck, Nic will be only too happy to help with his expert skills. It’s made a huge difference to the flow of our business, highly recommended. Thanks Nic and Jeff.
Robert Manning
Posted 11 Sep 2023
5 out of 5 stars

Great tool and support

Odatalink is great for connecting Xero to Power BI. The support we received from Nic regarding the Custom Functions in Power Query was excellent.
Warren Wilbraham
Posted 25 Jul 2023
5 out of 5 stars

Bringing Power BI to Xero to easy way

The Odatalink service is great. I have been able to build powerful and repeatable models for my clients using this service. Support from the team is quick, efficient and patient. It has a few nice features like IP address authorisation which is smart. The secret sauce is you want to bring your Xero reporting into PowerBI.

Response from OdataLink

Hi Warren, appreciate you taking time to write a review. The repeatable model concept is an advantage for analysts whereby you can duplicate your models and then hook them up with different clients data files

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.