How to connect xero API to PowerBI

[amaleranda]

Hi Gents, 

did anyone know how to connect xero API to PowerBI, I am stuck in the autthintication method.

[EugeneLebedev]

There are some third-party solutions out there that extract data from Xero to Power BI. Here is the approach I used before. It is great for combining data from multiple Xero accounts and customization of your data format since it is bespoke: https://vidi-corp.com/connect-xero-to-power-bi-tableau-excel-looker-studio/

[Anonymous]

@amaleranda - Take a look at this if this helps- https://apps.xero.com/nz/search/app/synchub

[amaleranda]

Hi, 

Thanks.

this is a paid app? I want to know how to connect using default auth methods if possible.

[Anonymous]

@amaleranda - I believe currently, power bi desktop doesn't have Xero connector which can connect to Xero directly.

An idea about this issue has been submitted in the Power BI ideas forum, which is under review, check the link below-
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7141465-connect-to-www-xero-com

So for now you would need to look for a third party app.