Matching 2 data sets with common key without VLOOKUP | Merge/Join data using Power Query | Power BI

Merge Queries in Power Query (Power BI) is which can help you VLOOKUP and give you all fields of matching data set. No multiple VLOOOKUPS to get multiple fields. If you have 2 data sets in Excel and you want to merge/join them and get the matching data with all fields of second data, try using Merge Queries in Power Query.

How can Merge Queries help you?
• E-commerce - After extracting products from 2 e-commerce websites, extract the model no and then use merge queries to join/lookup the data

• Food ordering apps - If you have same names of food items of same restaurant in 2 different food ordering apps, try using Merge Queries to join the data using food item name as common key and check the price difference in the 2 apps

• Personal use - Be it some same courses in 2 websites, or some 2 data sets with more than 1 common keys, join using Merge Queries

* The information on the videos and the resources available for download/viewing through this YouTube Channel are for educational and informational purposes only.​

[NeepraDigital]

Excellent tips, this can be very useful to novice
Can you please add few more videos <3