Building Custom Connector for Xero API

Hi Mark,

Nic here from OdataLink.

First off, (sorry about the plug), but if you want a simple way, try OdataLink.

https://odatalink.com/get-xero-data-in-power-bi/

From Jaime's main code, you'll want to ensure you edit the following two lines at the top of her code. You need to use your own client id and secret you registered with the xero app portal.

client_id = "3";
client_secret = "v";

Secondly, you need to use the following redirect uri that jaime used (unsure where she got that from). But this needs to match and be the same as how you setup your app.  You might just need to update your xero app listing to use the correct  value (it needs to be exactly as per below).

redirect_uri = "https://oauth.powerbi.com/views/oauthredirect.html";

From your screenshot, it's most likely related to three two values being wrong (either in your power query, or in the xer app).

Regards

Nic