ODataLink
  • Home
  • Pricing
  • Testimonials
  • Solutions
    • Reports, Dashboards and Templates
    • Tutorials
    • Get MYOB data into Power BI
    • Get MYOB data into Excel
    • Get Xero data into Power BI
    • Get Xero data into Excel
    • Online Help
  • FAQ
  • Blog
Magnifying glass
Trial
Login

The simplest way to connect Xero
with Power BI and Excel

Trial
Login
Try Xero for Free

What’s new in OdataLink for January 2024. Read more

What’s new in OdataLink for December 2023. Read more

Get started using pre-built reporting templates. Read more

Learn all about Power BI, Power Query, Excel and DAX. Read more

What is OdataLink?

A secure cloud service for Power BI and Excel users to create online dashboards and reports using live Xero data.

It’s like ODBC but for cloud Xero data.

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

Who is it for?

Managers and CFOs

  • Create your own KPIs.
  • Share them with stakeholders.
  • Monitor performance in real time.

Accountants and Advisers

  • Create a point of difference.
  • Attract loyal clients.
  • Expand recurring services.

Franchisors

  • Set benchmarks and systems.
  • Compare franchises.
  • Consolidate groupwide.

Why use OdataLink?

Cloud Based

Cloud-Based

  • Works from anywhere.
  • Easy to get started.
  • No software to install.

Read More…

Live Data

Live Data

  • Direct connection to Xero.
  • No synchronisation required.
  • Refresh data on demand.

Read More…

Secure

Secure

  • Data encryption
  • Two-Factor Authentication.
  • Firewall.

Read More…

Powerful

Powerful

  • Includes 30+ endpoints for Xero.
  • Includes IDs for accurate joins
  • Filters are passed directly.
  • Returns cached data if unchanged.

Read More…

OData v4 Compliant

Compatible with

  • Power BI (Desktop and Online)
  • Excel
  • Azure Data Factory
  • SQL Server Integration Services (SSIS)
  • Other OData v4 compliant clients

Read More…

Getting Started

OdataLink provides complete documentation which can be found at help.odatalink.com along with many videos.

You can also consult the Getting Started Guide.

Start your free trialFind out more

Pricing

For pricing information, see the pricing page.

About Xero

Xero is world-leading online accounting software built for small business.

Get a real-time view of your cashflow.

Log in anytime, anywhere on your Mac, PC, tablet of phone to get a real-time view of your cash flow. It’s small business accounting software that’s simple, smart and occasionally magical.

Run your business on the go.

Use our mobile app to reconcile, send invoices, or create expense claims – from anywhere.

Get paid faster with online invoicing.

Send online invoices to your customers – and get updated when they’re opened.

Reconcile in seconds.

Xero imports and categorises your latest bank transactions. Just click ok to reconcile.

Find out more or try Xero Accounting Software for free.

Try Xero for Free

Start your free trial
Try Xero for Free
  • OdataLink
  • Home
  • Pricing
  • Testinonials
  • Solutions
  • Tutorials
  • Reports, Dashboard and Templates
  • Online Help
  • Resources
  • News
  • FAQ
  • Search
  • About
  • About Us
  • Contact Us

OdataLink is developed by Accounting Addons.

OdataLink is officially certified and listed on the Xero App Store.

With over 20+ years of experience creating custom reports for Xero, Accounting Addons is a leader when it comes to creating integration solutions and custom reports for Australian and New Zealand businesses.

For more solutions for Xero, see the Accounting Addons website.

© 2025 Accounting Addons

Xero Connected App