Protected: Subscriber’s Resource: Robust Column Merge
This content is password protected. To view it please enter your password below: Password:...
Tag: Robust Queries
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...
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...
Robust Queries: Convert column types and merge columns without referencing column names
Converting column types, and merging columns are common transformations in Power Query. It is so easy to perform these transformations through the Query...
