How to Change Joining Types in Power BI and Power Query

Posted on July 31, 2015October 16, 2020 by Reza Rad

Joining tables is not a new concept, I bet all readers of my blog at least have a clue about that. However there are different types of joins, and applying these types of Joins are not all possible through Power Query GUI. Power BI recently took an step and implemented that in the GUI, however you might like to know how to apply that in the Power Query. The trick is that M is your friend, You can do whatever you want behind the scenes with M script.

[…]

Power BI Waterfall Chart: What’s That All About?

Posted on July 29, 2015July 30, 2019 by Reza Rad

You’ve heard the news about Power BI Desktop release with bunch of new features. If you don’t, read blog post here to understand new features of Power BI. Waterfall chart is one of the new visualization elements in this product. For finance people this chart makes sense, but not everyone knows the usage of that. In this post I want to explain what is Waterfall chart, when to use it? and how to use it? So you would learn what’s Waterfall chart all about?

[…]

SSAS Tabular Live Power BI Connection

Posted on July 27, 2015 by Reza Rad

When Power BI 2.0 released as General Availability I’ve published a post that highlights all new features in this product. One of the features was SSAS Tabular Live Power BI Connection. In this post I want to explore more what the Live connection means and what are advantages of this type of connection. Power BI Designer (Previous version of Power BI Desktop) was supporting offline connection to SSAS. The new SSAS Live connection of Power BI only works with SSAS Tabular at the moment.

[…]

Power BI: How to Analyze FIFA 2014 Worldcup

Posted on July 26, 2015 by Reza Rad

It was sometimes ago that I’ve posted some data analysis that I’ve done with Power BI Designer on FIFA 2014 Worldcup results. In this post I want to take you through the process of how to achieve that analysis. This post is an introduction to Power BI features with the example of FIFA 2014 Worldcup result set. Through this post you will learn how to connect to web based data sets and mash up the data with Power Query component of Power BI Desktop. And finally how to model it and visualize it in the Power BI report. Most of the data for this example comes from data sets in FIFA 2014 Worldcup official website: http://www.fifa.com/worldcup/archive/brazil2014/index.html

[…]

All in One: What’s New in Power BI Desktop 2.0 GA

Posted on July 25, 2015July 25, 2015 by Reza Rad

The Breaking news of General Availability of Power BI 2.0 in now everywhere all around the world. In this post I’ll illustrate some great new features of Power BI. if you would like to see a real world example of Power BI you can read FIFA 2014 Worldcup Data Analysis with Power BI, I’ll update that example later on with the new Power BI version. It has been a while that Power BI was on Preview, and with the great effort from Microsoft product team it is now available fully released. As per Microsoft blog post on 21st of July 2015 Microsoft mentioned some great features that will be available in this release, in this post we will go through them one by one. […]