Integrating multiple queries

The full power of Power BI's querying capabilities is in the integration of queries via it's merge and append operations. Retrieval processes which consolidate files from multiple network locations or which integrate data from multiple data sources can be developed efficiently and securely. Additionally, the same join types and data transformation patterns SQL and ETL developers are familiar with can be achieved with the M language.

This recipe provides examples of combining sources into a single query and leveraging the table join functions of M to support common transformation scenarios.

Getting ready

• To follow along with this recipe, you can use the Merge Queries and Append Queries icons on the Home tab of the Query Editor to generate the join expressions used in this recipe
• As joining queries is fundamental to the retrieval process, it's recommended to learn the Table.Join(), Table.NestedJoin(), and Table.Combine() functions

How to do it...

Consolidate files

The...