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 + 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
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.
- Or start with OdataLink's pre-built downloadable templates available as both Excel and Power BI versions. Explore all Xero templates on OdataLink's templates page.
