Overview
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.

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.
Getting started
To connect Xero with Power BI, Excel or Tableau using OdataLink is simple.
- Register and create an account.
- Configure the model and choose what data to access.
- Add your Xero Organisations.
- Use the provided OData Feed URL to create your live connection.
- Transform, analyse and visualise your data in your platform of choice.
Reviews & ratings
Most recent reviews
Phenomenal Service and Support
Great tool and support
Bringing Power BI to Xero to easy way
Response from OdataLink