Get Xero data into Power BI the easy way, using OdataLink.
Xero OData feed provider for Power BI
OdataLink is an OData feed provider that shapes the Xero data into a format that can readily be used by Power BI without the need for any external software, additional setup or complex programming.
It works with both the desktop and cloud versions of Power BI.
With OdataLink, accessing your Xero data is as simple as copying a URL and selecting the endpoints to retrieve. This approach completely bypasses the need for databases and data warehouses as your Xero data can be directly manipulated within Power Query.
In fact, OdataLink provides a live link to your data, sending any filtering or sorting directly to Xero for processing.
Over 70+ Xero endpoints available
OdataLink provides access to many endpoints for Xero including:
- 50+ endpoints for Accounting
- 20+ endpoints Payroll (Australia and New Zealand)
- All 4 endpoints for Projects
All these combined allows you to get data including:
- Invoices (which provides both Sales and Purchases)
- Payments, Prepayments, Overpayments and Credit Notes
- Purchase Orders and Sales Quotes
- Pay Runs and Pay Slips
- Projects, Tasks and Times
- And Meta Data such as Accounts, Contacts, Employees, Items, Pay Items, Tracking Categories, etc.
Simple and Expanded endpoints
In addition, for some endpoints, OdataLink provides two types. A simple endpoint and an expanded endpoint. This new concept is specific to Xero and the Xero API.
The simple endpoint (e.g. Invoices) provide a quick way to get all general data in one single request.
Alternatively, the expanded endpoint (e.g. InvoicesExpanded) includes additional data (e.g. Lines). In addition, OdataLink returns the data in increments of 100 records. Excel automates this completely automates this process behind the scene. This affords a more responsive process to downloading data for larger data sets.
While both types of endpoints aim to provide the same date, allowing two different ways to query it allows you to choose how to optimise your reports.
Simple and Expanded endpoints are available for :
- BankTransactions
- Contacts
- CreditNotes
- Invoices
- ManualJournals
- Overpayments
- Prepayments
Get Started with OdataLink
Register for your 30-day trial.