Forum Discussion
Using both Xero and Xero Practice Manager Datasets
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!
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".