Xero - Job/ tracking category

[angietse]

Hi there, 

I have my Xero integrated with PBI. The current Xero dataset doesnt include any of the tracking/ jobs relationship, therefore unable to pull out any job reports such as an individual P&L. 

Is there any solution on how to locate this or if there is anyway i could link this Xero dataset to PBI desktop for my own report?

Thank you 

[Jeff_Acc_Addons]

Hi @angietse 

Since writing your post there is now a cloud app that enables you to create a live connection to Xero from within Power BI using its standard Odata Feed connector. The end point that you would require is Journals to get tracking categories

https://developer.xero.com/documentation/api/accounting/journals/

Here is a link to the app

https://apps.xero.com/au/app/odatalink

Jeff

[Icey]

Hi @angietse ,

Currently, there is no Xero connector in Power BI Desktop. Here is a similar idea which you can vote up and post comments.

Refer to this post, you can use other connectors. And there is an extra charge.

Or, consider copying data from Xero using Azure Data Factory.

Best Regards,

Icey

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