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...
by Gil Raviv | Oct 7, 2016 | Popular
Converting column types, and merging columns are common transformations in Power Query. It is so easy to perform these transformations through the Query Editor user interface (as we will demonstrate in a minute), but sometimes, the auto-generated Power Query...
