Forum Discussion
Xero - Job/ tracking category
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
2 Replies
- Icey
Community Support
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.
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
