You’re on the United Kingdom site
Select a region

OdataLink

By Odatalink
4.86 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.9
out of 5
Reviewed by
28
Xero users
Try this app
Free trial
available
Key functions
Accountant tools
Reporting

OdataLink can help your business

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.9 out of 5 stars
28 Reviews

Sort and filter

Rating
Sort

Most recent reviews

TW
Tom Wood
Posted 17 Sep 2024
5 out of 5 stars
OdataLink is a great app for linking Xero to Excel, and particularly for creating dynamic consolidated aged debtor reports (in PowerBI too). Straight forward to set up and use, with a strong emphasis on the security of the data. Very responsive and proactive support team, always looking for positive solutions.

Response from OdataLink

Hi Tom, appreciate you taking the time to leave a review.
KA
Kathryn Allen
Posted 30 Aug 2024
5 out of 5 stars

Above and beyond customer service

Product is great, team is amazing. It's not financially viable for us to move to Office365 and we seemed to have an obscure version of Excel 2016 that didn't work with the template reports. Nicolas and his team worked tirelessly to customise some templates and create a solution for us. They were always so prompt in their responses and were very professional and kind to my non-developer brain! The product is great and means we don't have to keep logging into and exporting separate reports from Xero now, we have all the data we need to do some serious consolidated reporting across our different companies. I could not recommend this product more highly!
SS
Subha Srinivasan
Posted 30 Aug 2024
5 out of 5 stars

Excellent Team & Customer Support

Odata is an excellent tool to connect XERO data with PowerBI. The team did an amazing job from setting up our account and assisted us on time whenever we approach them. Thank you team.

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.