It is now possible to get live Xero data into Power BI and Excel using OdataLink.
This will allow you to start creating dashboards and reports using Microsoft Power BI and Excel using most data endpoints available in Xero.
News
OdataLink is now officially approved by MYOB after they reviewed and confirmed OdataLink for listing on the MYOB App Marketplace for both MYOB AccountRight Live and MYOB Essentials.
OdataLink now has a Free Edition which allows you to create custom reports and dashboards using MYOB AccountRight Live and MYOB Essentials in Power BI and Excel.