Merge Queries Power BI

Published on 18 Sep 2023:
In this video, we will learn to merge two data sets in power query editor. Think of this as joining two or more tables for those of us who come from the SQL world.
This is a denormalisation step. Just because we can merge queries does not mean we should merge queries.
There are valida scenarios we need to do this.
In the previous video, we learnt to pivot and transpose data in Power Query editor in Power BI.
When we converted row values to column headers, pivoting data removed duplicate rows.
When we convert row values to column headers, transposing does not remove duplicate rows.
SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel,SQL Server and Python!!
/ @learnexcelrelentless
Our Playists:
Getting Started with AWS: bit.ly/2PgSCQX
SQL Playlist :goo.gl/PS5Ep6
DAX PlayList : goo.gl/S4W41D
Power BI PlayList: goo.gl/dXxvnB
Power Query Playlist: goo.gl/5QS7P4
Getting Started with Power BI:goo.gl/GHakLZ
Getting Started with Python: goo.gl/n24P3w
Data Science With Python:goo.gl/PeYCR5
Power BI service: tiny.cc/sjekmz
PL 300 exam playlist: bit.ly/3wQ2d6C
ABOUT DAGDOO:
Website:
Home Page: www.dagdoo.org/
Power BI Tutorials: www.dagdoo.org/excel-learning/...
Questions? Comments and SUGESTIONS? You will find me here:
Twitter: @dagdooe
Category: Science & Technology
License: Standard KZbin License

[@youngthecreator22]

By creating a merged query, this means if there's an update in one of the dataset, that same merged query isn't updated?