by Gil Raviv | Jan 24, 2017 | Popular
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 you import data to Power BI, or to Excel (using Power Query / Get & Transform) – You remove...
by Gil Raviv | Jan 18, 2017 | Popular
Follow @gilra 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 today’s post, we will discuss the chaotic nature of column ordering in the Query Editor of...
by Gil Raviv | Jan 16, 2017 | Popular
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 common refresh errors. In today’s post, we will learn about the third pitfall, which is probably more...
by Gil Raviv | Jan 11, 2017 | Popular
Follow @gilra 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, or worse – show wrong results. In today’s post, we will focus on the second pitfall,...
by Gil Raviv | Jan 6, 2017 | Popular
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 term Robust Queries here, but I thought it would be important to provide a better coverage of this...
