If PowerPivot, Power Query, and Power View had a baby (don’t ask how) that baby would be called Power BI Desktop Designer. Yesterday the Power BI Desktop Designer was released for general availability, which I promptly downloaded last night at 11:30 PM EST and started playing with. Even as my wife turned out the light and begged me to go to sleep, I persisted! I was too excited. So here’s my first run through (I call it run through because it was late and I didn’t spend a ton of time looking at every little thing).
Download Power BI Desktop
Ok first things first. Download the Power BI Desktop Designer so you can start playing!
Installing it is pretty straight forward so I’ll spare you the details.
Get Data with Power BI Desktop
The first thing I did after installing the Power BI Desktop Designer was click the Get Data button.
This is where we can specify the data sources that we want to pull into our report. As you can see from the couple screenshots below, there’s a lot of choices for data sources similar to Power Query. If you’ve got data in traditional data sources like SQL Server, Oracle, DB2, you can access them here. I just have a boring Access database version of Adventure Works, so I’m going to select Access Database here.
Or if you have other less traditional data sources such as Facebook, Google Analytics, QuickBooks Online, or Salesforce, you’re covered.
Then I selected the tables that I wanted to import into my model and clicked the Load button.
The data is loading! Sweet!
After loading the data is completed, I’m presented with a blank screen where I can then begin designing my reports. There are three different views we can use to interact with our model: The Report view, Data view, and Relationships view. The different design interfaces can be accessed on the left side of the Power BI DD.
Creating Relationships in Power BI Desktop
The first thing I did was click the Manage Relationships button in the Home ribbon. This is where we can create and manage relationships between the tables in our model.
To create a relationship between two tables, you can either click New and manually specify the relationships between tables or click the Autodetect button to let the designer do it for you.
To create a relationship, just click New and select the tables from the drop down lists and highlight the columns to use in the relationship. Pretty easy.
If you want to manage your relationships in a GUI, just click over to the Relationships design interface to take a look at your model.
I want to point out a couple things here. You’ll notice in the relationships diagram that the arrows between the tables have a 1 and a * on the arrows between the tables. This indicates that this is a one-to-many relationship, which can be controlled from the Edit Relationship windows.
To manage a relationship between two tables, you can also just double-click the arrow between the two tables to open the Edit Relationship window.
Edit your Query with Power BI Desktop
If you need to apply some serious changes to your data then click the Edit Query button on the Home ribbon.
This is where things get Power Query-like. We can do a lot of things here just like we did in Power Query: Rename columns, control formatting, pivot or unpivot data, create new columns, modify data types, replace incorrect values, create a header using the first row, etc.
After you’ve made the necessary modifications to your query, go to File and click Close & Load to refresh your data.
Modeling your Data with Power BI Desktop
If you want to model your data, click on the Data view button to view your data like you were in Power Query.
From this view we can make modifications to the format and layout of the data. From here I can control formatting of the fields, hide columns, control sorting, or add calculated columns or measures.
To create a new measure or column, just click the button in the Modeling ribbon, write a little DAX, and you’re done. Numeric type fields in your data will automatically show up as implicit measures for your users, but in certain scenarios where you want to control the measure aggregation instead of leaving it up to your users, create an explicit measure as seen below.
If you have geography data you want to use in a map report, set the Data Category for the field appropriately so Power BI DD will know how to link the field to the map.
If you want to hide a field from the Report View, just right-click the field and select Hide in Report View.
Designing Reports in Power BI Desktop
Now its on to the fun part! Create reports is similar to Power View but there are some differences to the interface. In my opinion, Power View is much more intuitive than the Reports view in Power BI DD, but maybe it just appears that way since I’m not used to it. But still, it was pretty easy compared to designing a report in SSRS or Performance Point.
I created the new Funnel report type and modified the report to sort by Total Reseller Sales, the calculated measure I created earlier.
I also created a Map report to test out the Data Category setting.
When I was done creating the report I clicked the Publish button to deploy the report to the Pragmatic Works Power BI.
And there you have it. My first dashboard designed using the new Power BI Desktop Designer.
I did notice a couple little bugs with controlling the legend position in the map and some other formatting issues that I’m sure will get worked out through the upcoming frequent releases.
Once again, here’s the link to install Power BI Desktop Designer:
Use the following link below to see what’s new in the latest version of Power BI Desktop Designer and to get help on working with the tool.
There’s also a helpful guide and video to working with Power BI Desktop Designer that you can watch here:
Let me here your thoughts: What is everyone else saying about the Power BI Desktop? If you’ve had a chance to take it out for a spin, let me know!
Power BI Desktop Dashboard Examples
Here’s a dashboard I put together using some movie data I found online. There’s lots of formatting and color preferences to get used to in the new design interface.
Let me know what you think! I’d love to hear your feedback on the new Power BI Desktop app!
*Update: James Phillips, a VP at Microsoft, has corrected me in the comments on the name of Power BI Desktop. After GA, the tool is no longer called Power BI Desktop Designer. From henceforth it shall be known as Power BI Desktop. Now please ignore all the references to “Desktop Designer”. 🙂
**Update: As I continue to play with the Power BI Designer, I’ll post any new dashboards I create at the bottom here while learning the tool