EDIT: I recorded a detailed video on how to work with Parent Child hierarchies in Power BI: https://businessintelligist.com/?p=2603 I have been working with SAP data source lately. And in SAP dimensions, parent-child hierarchy is very common and there is a need to flatten it in Power BI. A common parent child hierarchy is an employee … Continue reading Power BI Tutorial: Flatten Parent Child Hierarchy
Category: PowerPivot
POWER BI TUTORIAL : Using Variables in DAX
Earlier this year, new version of DAX was released. One of the key features with this release is the support for variables. Variables makes writing DAX code easier. Variables also make code easier to read and understand. Download sample data here. Data represents sales for a particular store. Products are categorized by seasonality and color. … Continue reading POWER BI TUTORIAL : Using Variables in DAX
Power BI Tutorial: Generate ID field using Power Query
This tutorial is based on one of the earlier tutorials – How to Create a Star Schema Model. I strongly recommend that you go through it first to become comfortable with using Power Query to create facts and dimensions for your Star schema before we start working on ID generation. The data set that we'll … Continue reading Power BI Tutorial: Generate ID field using Power Query
Power BI Tutorial: How to Use Single Date Dimension in Your Model (using USERELATIONSHIP() Function)
Let's take a look at an unfortunately very familiar to most of us business scenario. A patient gets admitted to a hospital, spends several days there and then gets discharged (hopefully feeling much better 🙂 ). In this situation, we have two dates that describe this event, the date of being admitted and the date … Continue reading Power BI Tutorial: How to Use Single Date Dimension in Your Model (using USERELATIONSHIP() Function)
Power BI Tutorial: How to Create a Star Schema Model in Power BI and Power Pivot Using Power Query
Click Here to download this Tutorial file Very often our analysis starts with a flat data set that contains all of the pertinent columns in a single table that looks like the one above. As we can see, we can analyze this data using three different lenses or dimensions: Product Geography Date Unfortunately, if we … Continue reading Power BI Tutorial: How to Create a Star Schema Model in Power BI and Power Pivot Using Power Query
What is Power BI?
I find it interesting that after it's been out for a long while, and after some great attempts by non-Microsoft sources to provide an adequate definition, I am still struggling with being able to provide a succinct explanation of what Power BI is to my customers. My best attempt thus far has boiled down to … Continue reading What is Power BI?
Teradata, DB2, Folder and Many Others Now Supported via Power Query in Power BI Gateway
This is a biggie… a great number of new data sources is now supported for data refresh via a Power BI Gateway. Please follow this link for details. SAP Business Objects is not yet supported. I am particularly impressed with ability to refresh from folder (please note, only CSV files are supported, a folder full … Continue reading Teradata, DB2, Folder and Many Others Now Supported via Power Query in Power BI Gateway
Adding an Index Column to a Power Pivot Model using EARLIER() DAX Function
This post will be a little bit atypical compared to what I normally write about. I usually don't focus on topics like the one described below because there are plenty of other blogs that cover developer specific issues related to using DAX. However, I ran into an issue few days ago, could not find a … Continue reading Adding an Index Column to a Power Pivot Model using EARLIER() DAX Function
How to Use Pictures in Your Power BI Power View Dashboards
If you used pictures in your Power View dashboards and tried to deploy these dashboards in your Power BI tenant you are likely to have seen the following warning message: "UNSUPPORTED FEATURES External pictures can't be displayed in Power View Sheets in Office 365". My guess it's only a matter of time when external pictures … Continue reading How to Use Pictures in Your Power BI Power View Dashboards
Date Management Gateway Now Supports Refresh from Power Query
Time for another correction… A couple of months ago I wrote a post about how to load data into a Power Pivot model using Power Query. As I was writing it, I was very excited about being able to decouple my Power Pivot models from physical data by using Power Query. Unfortunately, at a time, … Continue reading Date Management Gateway Now Supports Refresh from Power Query
business intelligist 