Role-playing dimension is one those concepts that is discussed a lot from time to time. I also posted an article about implementing role-playing dimensions in Tabular models. In one my recent posts I used the same concept to implement role-playing dimensions in Power BI. So in this post I’m not going to explain role-playing dimensions in Power BI again.
In some cases you need to have especial calculated measures based on the roles you have in a fact table. One the most common role-playing dimensions is Date dimension. Consider you have to show Internet Sales Amount by Order Date, Due Date and Ship Date in a single chart in your report. In this case, having 3 different date tables won’t help us to achieve the goal. Again I refer to my previous post where I said I keep the original Date table in the model for a reason.
Defining a new Calculated Measure in Power BI Desktop
Basically, what I’m going to explain in this post is using inactive relationships between FactInternetSales table and the DimDate dimension by adding a new Calculated measure. In this case, we’ll be able to show Sales Amount by different roles, well, dates in this sample in a single chart.
Continue reading Side-by-side Role-Playing Dimensions In Power BI
One of the most interesting things about Power BI is that it covers a wide range of areas. Therefore, it can help a wide range of different users to analyse and understand their businesses easily. For instance system administrators can use Power BI to analyse their Microsoft Windows Active Directory. As a matter of fact, Power BI and Active Directory can work together very nicely so that a system administrator can create high level reports and dashboards.
In this , we’ll create a report of the following charts:
- Total number of computers by Operating System/Service Pack
- Total number of computers by year and Operating System
- Total number of computers
- Print pages per minute by printer
- Total number of printers by year and driver name
As a system administrator you can create heaps of other useful reports.
- On Power BI Desktop click “Get Data” then click “More”
- Click “Other”, click “Active Directory” then click “Connect”
- Enter a Domain name then click OK
- As you can see there are 374 tables you can select to create heaps of reports. In this post I use “Computer” and “PrintQueue”
Continue reading Power BI and Active Directory for System Administrators
In this post I explain how to use MySQL and Power BI. This post covers the following areas:
- Get data from MySQL
- Schedule refresh on-premises MySQL from power BI web app
First of all I’d like to mention that in this post I use AdventureWorksDW which is imported into MySQL. If you want to do so you can use “Migration Wizard” from “Database” menu on MySQL Workbench.
I’m not going to explain the migration process as it’s out of scope.
How MySQL and Power BI work together
MySQL is one of the world’s most popular relational database management systems (RDBMS) widely used by the industry. It’s open source, works with many different system platforms including Microsoft Windows and Linux. So it is worth to have a look at it and see how it works with Power BI.
Luckily Microsoft provided the built-in connector in Power BI Desktop. This is how it works all together:
I’d like to say that it’s not necessary to create reports in Power BI Desktop. You can get data from a MySQL database then publish it to the Power BI cloud then setup a schedule data refresh in the Power BI web app. Then you can create your reports and dashboards on the cloud and share them with your colleagues very easily.
Continue reading MySQL and Power BI, How Does It Work?
As most of you guys know Power BI Desktop is released. I should say, it’s awesome. There are heaps of changes in compare with its preview edition Power BI Designer. I’ve written a series of posts regarding creating a report and dashboard using Power BI Designer before. You can find them here. Now I want to explain the same thing in Power BI Desktop. I’ll cover lots of new features in this post and I hope you enjoy it.
We use Adventure Works DW 2012 database as sample, you can open your real world data source
Click on “SQL Server Database” then “Connect”
In this sample we are connecting to a “SQL Server Database”
Continue reading Data Visualisation with Power BI Desktop