Showing results for 
Search instead for 
Did you mean: 
New Member

Xero Integration - Customer Account Number

We use te Xero Template App to ingest financial infomation which is great, but is there a way to configure what data gets pulled from Xero?

Specifically, we want to be able to include the customer account number, so that we can pair the customer transaction data in Xero with usage and activity data in our other systems.

Does anyone know if there's a means of customising the schema, or would we effectively have to write our own integration from scratch?

Community Support
Community Support

Hi @MatthewTaylor ,



Have you tried this connector in Power BI Desktop?


Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Lionel, this is indeed the one we are using. Unfortunately it only seems to show the customer name but not number at present. This is why I was curious if anyone knew if it was possible to configure it to somehow pull the customer number as part of its schema. Eager to avoid reinventing the wheel if it's already doable.


Thanks for your reply,


Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors