Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to Setup Xero connection to Power BI

Hi   I am new to Power BI and have been trying to setup our organizations Xero connection to Power BI.  I cant seem to find Xero in the connected apps in Power BI? Anyone have ideas on what I could...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous ,

    Sorry for the delay.

    Update: the Xero app was republished as a Template app, you could find it from here.

    By my test, we could get it in app list now.

    Best  Regards,

    Cherry

     

kevinwiegand's avatar
kevinwiegand
Frequent Visitor
6 years ago

Hi Sane,

 

There are three ways;
1) log into powerbi.com -> Get Data -> Xero App (downside is you can't edit / consolidate / add data / create measures)

2) export CSV's from Xero -> PowerBI Desktop -> Publish to powerbi.com (manual, error prone, not scalable)

3) Programatically update an Azure SQL DB -> Power BI Desktop (Direct query) -> Publish to powerbi.com (automated, scalable, and the start of something beautiful)

 

We have a connector which helps you achieve step 3). You can read more about here : https://datasights.co/integrations/xero-connector/

Good luck!