#MSDataSummit Ten Pitfalls of the Data Wrangler using Power BI
Meet Alice the Power BI Data Wrangler, and DBA Bob, and learn how Alice can survive the 10 pitfalls when there is no proper data contract with Bob. Here is...
Tag: Pitfalls
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...
10 common mistakes you do in #PowerBI #PowerQuery – Pitfall #3
Prologue In our last episode of the Pitfalls series here, we were introduced to Pitfall #2 - The automatic detection of column types, which can trigger...
10 common mistakes you do in #PowerBI #PowerQuery – Pitfall #2
In the last blog post, we outlined the challenge in creating robust queries that will be resilient to changes in data structure, and will not fail a refresh,...
10 common mistakes you do in #PowerBI #PowerQuery – And how to avoid pitfalls
This is the first article in a series I would like to call Robust Queries in Power BI and Power Query. To follow this series click here. I've already used the...
