In previous post “Rise of the Power BI“, we have discussed about the Power BI and it’s components. In this post “Drill down report in Power BI”, we are going to learn how we can create a drill down report in Power BI.
To demonstrate the Power BI drill down functionality, we are loading the sample data using a SQL query from “AdventureWorks2014” database. Power BI desktop provides a direct connectivity to SQL Server which we are going to use in this tutorial.
Lets, load the data into power BI to create a drill down report:
Loading data into Power BI from SQL Server
To create a SQL Server connection to pull data from AdventureWorks2014 Database, follow below steps:
- Open Power BI Desktop application.
- A dialog box will appear at startup screen, click on “Get Data” button appearing at left of the dialog box.