Chapter 5: Combining Queries for Efficiency

Business analysts need to perform complex transformations that usually involve a combination of multiple queries. They often need to join data horizontally or to append tables.

With different ways of combining data, you can transform and model tables in order to optimize the information included. By leveraging different methods, you can perform merge and join transformations in order to enrich data or append and combine queries to scale and increase data volume automatically. The main aim is to create queries with relevant data that can serve different purposes, such as reporting, loading to Dataverse through Power Apps, or loading to Azure Data Lake to make this data available for other applications. ...

Get Power Query Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.