Compare different files QUICKLY using Power Query in Power BI // Beginners Guide to Power BI in 2021

In this video we go through how you can use Power Query to verify the integrity of your migrated files. This method could be re-used to save time when comparing two sources against each other. - 🚩 Support us to get perks such as demo files, early access and more! Ā Ā /Ā solutionsabroadĀ Ā  MY FAVOURITE POWER BI BOOKS šŸ“• The Definitive Guide to DAX - https://amzn.to/3ruYs2f šŸ“— DAX Patterns - https://amzn.to/3oVgOYs MY GEAR šŸŽ„ Canon 4000D DSLR Camera - https://amzn.to/3tCqDOw šŸ’» Cyberpower Wyvern PC - https://amzn.to/3q04QOw šŸŖ‘ Infamous Gaming Chair - https://amzn.to/3q3iUXw šŸ’” LED Studio Lighting - https://amzn.to/3q3ftQz šŸŽ™ Lavalier Microphone - https://amzn.to/3jwKutG šŸ“ŗ Monitor - https://amzn.to/2LuHhhO GET IN TOUCH šŸ“ŗ Website - www.solutionsabroad.co.uk šŸ“§ Email me - [email protected] 🤵 LinkedIn - Ā Ā /Ā solutionsabroadĀ Ā  šŸ“˜ Facebook - Ā Ā /Ā solutionsabroadĀ Ā  šŸ“ø Instagram - Ā Ā /Ā solutions_abroadĀ Ā  🐤 Twitter - Ā Ā /Ā abroadsolutionsĀ Ā  šŸ¤– Reddit - Ā Ā /Ā fernanespejoĀ Ā  šŸŒ WHO IS SOLUTIONS ABROAD Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube. If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you. šŸŽ First, watch this video about how a typical Power BI workflow looks like    • PowerĀ BIĀ fromĀ STARTĀ toĀ FINISHĀ -Ā TypicalĀ Po...Ā Ā  šŸ—ŗ Learn DAX to extend your Power BI calculations    • PowerĀ BIĀ DAXĀ BasicsĀ OLDĀ Ā  šŸ“† Stay up-to-date on all the features Power BI releases monthly    • PowerĀ BIĀ MonthlyĀ FeatureĀ OLDĀ Ā  🧪 Get certified as a Microsoft Data Analyst Associate    • PowerĀ BIĀ DAĀ 100Ā PreparationĀ Ā  šŸ’” Learn Power BI Features to improve your dashboards    • PowerĀ BIĀ FeatureĀ HighlightĀ OLDĀ Ā  šŸ“Š WHAT IS POWER BI? Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more. šŸ”» Get started with Power BI Desktop for FREE https://powerbi.microsoft.com/en-us/d... #PowerBI #DataAnalytics #BusinessIntelligence

How to use Microsoft Power Query
ā–¶ļøŽ

How to use Microsoft Power Query

Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!)
ā–¶ļøŽ

Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!)

7 Power Query Tricks You’ll Regret Not Knowing
ā–¶ļøŽ

7 Power Query Tricks You’ll Regret Not Knowing

TOP 5 HR Metrics you SHOULD BE TRACKING and How to Calculate them in Power BI
ā–¶ļøŽ

TOP 5 HR Metrics you SHOULD BE TRACKING and How to Calculate them in Power BI

Power Query for Beginners: Transform Excel Data in Minutes  (2025 Tutorial Part I)
ā–¶ļøŽ

Power Query for Beginners: Transform Excel Data in Minutes (2025 Tutorial Part I)

Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
ā–¶ļøŽ

Power Query - Avoid "Helper Queries" (+10 Cool Tricks)

Compare two tables using DAX in Power BI | EXCEPT and UNION DAX functions
ā–¶ļøŽ

Compare two tables using DAX in Power BI | EXCEPT and UNION DAX functions

each & underscore_  in Power Query Explained
ā–¶ļøŽ

each & underscore_ in Power Query Explained

How to use PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSYEAR // Beginners Guide to Power BI
ā–¶ļøŽ

How to use PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSYEAR // Beginners Guide to Power BI

Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)
ā–¶ļøŽ

Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)

Hands-On Power BI Tutorial šŸ“Š Beginner to Pro [Full Course] 2023 Edition⚔
ā–¶ļøŽ

Hands-On Power BI Tutorial šŸ“Š Beginner to Pro [Full Course] 2023 Edition⚔

How To Compare Excel Files and Find Differences
ā–¶ļøŽ

How To Compare Excel Files and Find Differences

Power BI Basics Beginner Tutorial
ā–¶ļøŽ

Power BI Basics Beginner Tutorial

How to use DYNAMIC ROW-LEVEL-SECURITY (RLS) in Power BI // Beginners Guide to Power BI in 2021
ā–¶ļøŽ

How to use DYNAMIC ROW-LEVEL-SECURITY (RLS) in Power BI // Beginners Guide to Power BI in 2021

Power BI FULL COURSE for Beginners | Learn Dashboards & Reports Fast!
ā–¶ļøŽ

Power BI FULL COURSE for Beginners | Learn Dashboards & Reports Fast!

How to use Power Query to Combine Multiple Files that have different headings
ā–¶ļøŽ

How to use Power Query to Combine Multiple Files that have different headings

Advanced Group By Tricks in Power Query
ā–¶ļøŽ

Advanced Group By Tricks in Power Query

Getting Started With M Language in Power Query | Basic to Advanced
ā–¶ļøŽ

Getting Started With M Language in Power Query | Basic to Advanced

Merging Queries and Understanding Join Kinds in Power Query (Power BI & Excel)
ā–¶ļøŽ

Merging Queries and Understanding Join Kinds in Power Query (Power BI & Excel)

šŸ“Š How to use Power BI DAX - Tutorial
ā–¶ļøŽ

šŸ“Š How to use Power BI DAX - Tutorial