You’re on the Singapore site
Select a region

OdataLink

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

Overview

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.

ODATALINK IS PERFECT FOR:

  • 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.
OdataLink
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
21 Reviews

Sort and filter

Rating
Sort

Most recent reviews

TG
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.
NL
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.
DC
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.
One person found this review helpful.

Additional info

Shared data

Xero
OdataLink
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

Functions

Accountant toolsReporting

Industries

Professional servicesAccounting

App details

By Odatalink

Countries

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

Languages

English

Support

Setup walkthroughContact supportcontact@odatalink.com

Contact

610883772144

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.