Importing Data from Xero

Nimai123 , There seems to be app in power bi service -https://docs.microsoft.com/en-us/power-bi/connect-data/service-connect-to-xero

For Desktop there are custom connector avaiable from third pary vendors

Nimai123  the Xero App will likely not cover your requirements as edit options are very limited and it also doesn't cover consolidation. I would recommend https://appsource.microsoft.com/en/product/power-bi/managility.xeroreporting?tab=Overview . This app automatically creates ab Azure SQL data warehouse with all Xero data to which you can add as many Xero companies as required  and combine it with data from other ERP/Accounting systems and SaaS sources. It also supports full statutory consolidation (e.g. intercompany eliminations, etc.) as well as currency conversions (local company>group). The solution also creates Power BI data models with all required DAX measures and 15+ best practice Power BI reports and offers planning and write-back. It has a price tag of $49 p.m. per company or $299 p.m for ten companies but that is likely well worth it as you will save thousands in implementation efforts and consulting services.