Forum Discussion

rbalza's avatar
rbalza
Helper III
5 years ago

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!

Need Help
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      MrSamGray
      New Member
      3 years ago

      Hi Anonymous ,

      Any updated link? That one is 404 now

      Sam

  • fabiobell's avatar
    fabiobell
    Regular Visitor
    3 years ago

    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".