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...
Category: Popular
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...
Power BI – Improved Query Function Authoring
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...
Improve refresh time by batching Web API calls – Yahoo Finance example
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...
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...
Sentiment Analysis in Power BI – Part 2
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...
Use DAX for dynamic events in Power BI Pulse Chart
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...
Faster Matrix Mulitplication
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...
