Compare Tables in Excel & Power BI
Do you often find yourself in dire need to compare two tables in Excel? In today's blog post, we will create an Excel workbook that compares two tables, and...
Tag: Power Query
Web Scraping in Power BI and Excel Power Query
There are abundant public data sources on the Web, and it is so tempting to import and mash them up with your existing data sets in Power BI and Excel Power...
Protected: Subscriber’s Resource: Bypass Web Proxies – Sample Query
This content is password protected. To view it please enter your password below: Password:...
Text Obfuscation in Power BI and Power Query in Excel
Power BI and Excel offer a wide variety of collaboration and sharing experiences. In today's blog post, we will share a useful method to easily obfuscate /...
Remove Duplicates, Lookup Tables and Pitfall #10 in #PowerBI and #PowerQuery
In today's post, we will learn about the tenth pitfall in Power BI and Power Query in Excel (Read all pitfalls here). For this special occasion, we'll get...
Expand Table Column – Pitfall #9
It's time to expand table columns today, and get you acquainted with the ninth pitfall, which can be quite risky, as you'll soon find out. For those of you...
Split & Merge Columns – Pitfalls #7 and #8
In today's post, we will introduce the 7th and 8th pitfalls in Power BI and Power Query in Excel. To follow the pitfalls series, go here. The 7th and 8th...
Column Renaming and List.Zip To The Rescue – Pitfall #6 in #PowerBI #PowerQuery
Today, we will learn how to avoid the 6th pitfall as part of the Power BI / Power Query Pitfalls series. The sixth pitfall is quite tricky, and is one of the...
Removing/Selecting Columns – Pitfall #5 in #PowerBI and #PowerQuery
In today's episode of the Pitfalls Series (here), we will briefly discuss the fifth pitfall, which is one of the most common mistakes that you always do, when...
Column Reordering Disorder – Pitfall #4 in #PowerBI #PowerQuery
Order is a crucial force in life, especially if you are a data analyst. But as we will see today, the misuse of order might cause an unexpected chaos. In...
