Just completed a project using PowerQuery to transform and analyze data! I leveraged AppendQueries to combine datasets, mergeQueries to join tables, and PivotTables to visualize insights. Applied data modeling techniques to create a robust and scalable data structure.

@srenders @ajkauffmann You can merge entities. E.g., select the CustomerLedgers entity, then click CombineTables->MergeQueries and merge it with the Customers entity. Works beautifully as far as I can tell, however, it does require the expensive Premium license

All about #MergeQueries in #PowerQuery, learn with our new video: