Using both Xero and Xero Practice Manager Datasets

[rbalza]

Hi PowerBi Friends,

Just wondering if anyone here using both xero blue and xero practice manager as datasets. I mean, what are the best practices of using both datasets in one report? Thanks!

[fabiobell]

One option is to build custom connectors, it works for both for Xero and Xero Practice Manager APIs. It is most definetly not a straight forward solution, and it requires a good deal of development. Here is Microsoft documentation to be used as reference: Power Query SDK overview - Power Query | Microsoft Learn.

Once built, you can access the databases as an available option in "Get Data".

[v-stephen-msft]

Hi @rbalza ,

Please kindly refer this which might be helpful

Connect to Xero with Power BI

Best Regards,

Stephen Tao

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

[MrSamGray]

Hi @v-stephen-msft ,

Any updated link? That one is 404 now

Sam