What’s New In Power BI August 2015 Update

Almost one month ago Power BI has been released for general availability with shiny new features, and I’ve wrote a blog post about new features in Power BI 2.0 General Availability. at 20th of August Microsoft released an August 2015 update version of Power BI Desktop with some new features. In this post I’ll go Read more about What’s New In Power BI August 2015 Update[…]

What Is Power Query? Introduction to Data Mash-up Engine of Power BI

When you get data in Power BI you actually use Power Query Component. In this chapter you will learn about What Power Query is, and what are different types of sources that Power Query can connect. Power Query has also great list of transformations that can be applied on the data set as well (which Read more about What Is Power Query? Introduction to Data Mash-up Engine of Power BI[…]

Power BI Website: You’ll Need Just A Web Browser

In previous section (from the Power BI from Rookie to Rockstar book) you’ve learned about Power BI Desktop, and you’ve developed a sample report with that and published it to Power BI website. In this section I’ll explain some of Power BI website’s functionality. You will understand at the end of this section that Power Read more about Power BI Website: You’ll Need Just A Web Browser[…]

Introduction to Power BI: What is Power BI?

As promised I started writing blog post series for the Online Book: Power BI from Rookie to Rockstar, and this is the first post. Power BI is not a new name in the BI market, components of Power BI has been in the market through different time periods. Some components such As Power BI Desktop Read more about Introduction to Power BI: What is Power BI?[…]

Online Book: Power BI From Rookie to Rockstar

The idea of writing a book on Power BI is not new for me, I’ve been thinking about it for a while, even before the first release of Power BI Designer. However, Power BI is fast-paced technology, Microsoft Product team is doing a great job with monthly, and sometimes even more frequent updates. With this Read more about Online Book: Power BI From Rookie to Rockstar[…]

Fetch Files and/or Folders with Filtering and Masking: Power Query

4

Fetching list of Files in a folder is easy with Power Query, it is one of the built-in source types. However fetching list of folders is not a built-in function. In this post I’ll show you how to fetch list of files, and also fetch only list of folders. The method explained in a way that you can customize the code and apply any conditions as you want later on. Conditions such as File or folder name masking to fetch only names that contains special character strings.

[…]

Hybrid, End-to-End; Power BI, Azure SQL Database, Data Factory

1

With the announcement of Power BI a week ago and with great features in this product, there are many opportunities that this product and service can be used. Power BI can be used alongside some other Azure services, and even On-Premises services to build an end-to-end enterprise BI and Data Analysis Solution. In this post I’ll just explain one example scenario of Hybrid and End-to-End BI solution that uses below technologies;

  • Data Sources On-Premises
  • Azure Data Factory or SSIS with Azure Pack for Data extraction and transformation
  • Azure SQL Database or Azure SQL Data Warehouse as the database / data warehouse engine in cloud
  • Power BI as the data analysis and front-end tool

[…]

How to Change Joining Types in Power BI and Power Query

0

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 Query Function that Returns Multiple Values

5

Yesterday in NZ BI user group meeting, I’ve been asked that does Power Query custom functions return only one value as the result set? or they can return multiple values. I’ve answered Yes, and I’ve explained that through a sentence how to do it with Records, List, or Table. Then I thought this might be a question of many people out there. So I’ve wrote this blog post to illustrate how to return multiple values from a custom function in Power Query.

[…]

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

7

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?

[…]