Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 be missing in the setup? All the documents and videos online appear to be very simple and straight forward but I must be missing an important step cause Xero isnt available in the Services Apps in my Power BI.
Help!
TIA,
Sane
Solved! Go to Solution.
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
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!
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
As mentioned before, the connector has been deprecated and if you'd like to create a new connector, you'd need to use the specific Power BI Custom Connector SDK.
More information about that SDK here:
https://docs.microsoft.com/en-us/power-query/startingtodevelopcustomconnectors
Hi @Anonymous ,
By my tests and research, this bolg has announced that the Xero contact pack is deprecated, so we cannot find it in power bi service any more.
You may try with web connector in power bi desktop if you have the api of xero.
Reference: API Strategies with Power BI
Best Regards,
Cherry