Best practice for merging various Xero Organisations into one dashboard?

[jcmkckenzie]

Hi Guys!

I am currently building a financial dashboard on PowerBi Desktop, I currently have 3 organisations on Xero (3 Businesses) from which I am pulling data through a 3rd party connector called SyncHub. I have created a dashboard where you can see the origanisations individually per tab, however I am now creating a tab where I will be reporting or visualising on the 3 organisations as a one, I have decided to append quries on power query editor, however I was wondering if there is a better and more efficent way of doing it? I appreciate your help, Ive started using PowerBi this year and I am still learning how to use it efficently.

Thanks, I appreciate your help!