Earners of the Power Query and Power Automate have learned to get data from different sources and manipulate it in cleaning, transforming, merging and appending using a straightforward interface add-in to Microsoft Excel, turn business processes into automated, interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions.