In this video, I’ll demonstrate how to use some of the advanced functionality in the power query editor to query things from Microsoft Dynamics 365 Business Central/Tensoft SemiOps/ DemandOps or any OData source. Firstly, I’ll cover how to combine queries together in two different ways – Merge and Append. Merge is joining two related datasets […]