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...
Follow Me Power BI Desktop November Update (2016) is out with amazing new features. In today's blog post, I would like to focus on a new functionality which...
Follow Me In today's blog post we will learn a neat Power Query trick that is extremely useful in improving refresh time on certain Web API calls (Like Yahoo...
Converting column types, and merging columns are common transformations in Power Query. It is so easy to perform these transformations through the Query...
Beyond 1000 Messages Today's blog post will take you one step further with Sentiment Analysis in Power BI and will show you how easy it is to extend the...
The Power BI team recently announced the release of the Pulse Chart custom visual. Excited by its potential, I decided to show you today how to define...
As a followup for our recent Matrix Multiplication post here, I would like to share with you a faster query for Matrix Multiplication (Faster only relative to...