by Gil Raviv | Mar 20, 2017
by Gil Raviv | Feb 14, 2017 | Popular, Power BI, Power Query
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 some help from R2-D2 and his friends, and demonstrate the pitfall with Star Wars data. Are you a...
by Gil Raviv | Feb 7, 2017 | Popular, Power BI, Power Query
Follow @gilra 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 who didn’t read my previous articles of the Pitfalls Series, you are welcome to...
by Gil Raviv | Jan 24, 2017 | Popular, Power BI, Power Query
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, Power BI, Power Query
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...