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...
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...
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...
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...
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...
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...
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...
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...
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,...
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...