I am pleased to announce that OdataLink will soon be available for Xero.
(Update: Xero is now available.)
This will allow you to start creating dashboards and reports using Microsoft Power BI and Excel using all data available in Xero.
As a first step, we are focusing only on the accounting endpoints. Payroll and other endpoints (e.g. assets, etc.) will be available at a later time.
We currently have over 20+ endpoints integrated with 10 or so remaining to be done.
We hope to be able to release this update by the end of March 2021.