Xero - beautiful accounting software

Xero Developer Help Center

Xero Developer Community

Community > Getting Started >

Data Schema of PowerBI Xero App or Xero Website Dashboards

Started by Themis A -   in Getting Started

Hello,

We have been using the dashboards from Xero App on PowerBI and we would like to recreate them on PowerBI desktop.

We have created a connection to Xero database and we now have access to all Xero tables but we want to see what is the data schema (e.g. how the tables are linked) of Xero App tables so as to recreate something similar on PowerBI desktop .

We also want the same for the Dashboards which are available on Xero Website. What is the data schema behind of how the tables are linked so as to produce the online reports (e.g. the P&L or Trail Balance report). Doing reverse engineering can be a bit difficult.

Any help will be greatly appreciated.

Thanks
T
> What is the data schema behind of how the tables are linked so as to produce the online reports.

XERO is exposing API's rather than raw tables. To generate those reports if you are not using the report builders themselves you need to go vanilla and link them up. P&L reports from my understanding can be done through the Invoices API as both bills and invoices are exposed within that API; information on whether they've been paid is also available.
 

Jonathan Mifsud