Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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".
Hi @rbalza ,
Please kindly refer this which might be helpful
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.