Power BI Tutorial - Dashboards
Posted by Superadmin on August 19 2020 19:14:13

 

Power BI Tutorial on Dashboards

 


The Power BI tutorial on Dashboards, adding report items to the dashboard, and publishing them.

  1. Register to Pro Service
  2. Dashboard Introduction
  3. Connect Desktop with BI Service or Pro
  4. Publish Desktop Reports
  5. Create a Workspace
  6. Create a Dashboard
  7. Favourites

 

 

Register to Power BI Service

Power BI desktop is the local version, where you can design your reports. But, in real-time, you have to share your work (reports) and dashboards across your organization. For this, you need a Premium license. However, you can try Power BI Pro 60 days trail. Let me show you how to register for Power BI Service.

 

How to register to Power BI Service

First, go to the official Microsoft Power BI website by clicking this link Power BI Pro. Next, click on the Try Free button to start your Power BI 60 days trial.

Register to Power BI Service 1

Clicking the Try Free button open Get Started window. Here, you have to provide the company email id. Remember, it won’t accept your personal email like Gmail.

Once you click the Sing up button, Power BI sends a verification code to the email that you provided. You have to use this verification code on the next screen.

Register to Power BI Service 2

Next, fill these text boxes with your personal information.

  Register to Power BI Service 3

Now you can see the Power BI workspace.

Register to Power BI Service 4

 

 

Power BI Dashboard Introduction

This article is an introduction to Power BI Dashboard. When you open or logged into a Power BI Service, you can see the Default Power BI dashboard.

  

If this is your first time, then the Power BI Dashboard displays the below page

Power BI Dashboard Introduction 1

Power BI Favorites

If you find something interesting, I mean a report or a dashboard, then you can add them to favorites for quick access. Those items will display in this section. I suggest you refer to the Power BI favorites article to understand the addition of dashboards and reports to Power BI favorites.  

 

Power BI Dashboard Introduction 2

Power BI Recent

Same as Recent files in Windows. It displays the reports, dashboards that we have seen recently.

Power BI Dashboard Introduction 3

Power BI Apps

Power BI Apps are a collection of reports and dashboards that helps you to analyze the business. This section displays the available Apps.

  Power BI Dashboard Introduction 4

Power BI Shared With Me

If someone in the organization shared a report or dashboard with you, then those shared items displayed in this section. Please refer to Share a Dashboard, and Share a Report article to know about the sharing options.

Power BI Dashboard Introduction 5

Power BI Workspaces

Power BI Workspace is a collection of Dashboards, Reports, Workbooks, and Datasets. It displays the workspaces that are available for this account. I suggest you refer to Create Power BI Workspace article to understand the creation of workspace.

Power BI Dashboard Introduction 6

My Workspace in Power BI

This is the default workplace created by the Power BI service, and this is the default one too.

If you are opening this Service for the first time, then it may display the below shown page. You can use this page to import data for creating visualizations.

Power BI Dashboard Introduction 7

By clicking the Skip button, or clicking the My Workspace tab opens the following window.

Power BI Dashboard Introduction 8

 

 

 

Connect Power BI Desktop with Power BI Service

In this section, we show you how to connect Power BI Desktop with Power BI Service or Power BI Pro. It is very important to publish your reports.

 

TIP: I suggest you refer Register to Power BI service article to create a Power BI account.

How to connect Power BI Desktop with Power BI Service

If you haven’t started the Power BI Desktop yet, Double click on the Power BI desktop to open. Once it is open, it asks you to register or to sign in as we below screenshot. You can use this form to create a new account.

Please click on the Already have a Power BI account? Sign in hyperlink

Connect Power BI Desktop with Power BI Service 1

Clicking the hyperlink opens a Sign in window. Here, you have to provide the username.

  Connect Power BI Desktop with Power BI Service 2

Connect Power BI Desktop Approach 2

Somehow if you forgot to log in when the Desktop is loaded, then you can follow this approach.

Click on the Sign in hyperlink in the top right corner.

Connect Power BI Desktop with Power BI Service 3

Please provide the Email Id that was provided by your company.  Remember, it only accepts organization ids, not your personal email accounts like Gmail.

Connect Power BI Desktop with Power BI Service 4

Please provide the password

Connect Power BI Desktop with Power BI Service 5

Now you can see that I logged in as Suresh.

Connect Power BI Desktop with Power BI Service 6

 

 

 

Publish Power BI Desktop Reports

In this article, we show you the step by step approach in publishing Power BI desktop reports into Power BI Service with a practical example. Before you start publishing reports in Power BI Desktop, you have to sign in to your account using Pro credentials.

  

TIP: I suggest you refer Connect Power BI Desktop with Power BI Service article to understand the procedure to sign in Power BI.

Publish Power BI Desktop Reports 1

How to Publish Power BI Desktop Reports

Please Navigate yourself to the Home tab, and click the Publish button on the Top right corner.

Publish Power BI Desktop Reports 2

Clicking the Publish button opens a new window called Publish to Power BI. Under the destination section, you have to select the Workspace (if any); otherwise, select the default My Workspace.

Publish Power BI Desktop Reports 3

Please wait until the publishing finished.

  Publish Power BI Desktop Reports 4

As you can see from the screenshot below, the report is published successfully. By clicking the Open Report hyperlink, you can see the report, and by clicking the Quick insights, you can see the data insights.

Let me open the Report in Power BI

Publish Power BI Desktop Reports 5

Now you can see the Report 1 inside your Workspace -> Reports tab. Click on Report 1 to see the pages inside that report

Publish Power BI Desktop Reports 6

You can see the pages in the Report

Publish Power BI Desktop Reports 7

 

 

 

 

 

Create Power BI Workspace

Power BI Workspace is a collection of Dashboards, Reports, Workbooks, and Datasets. The Power BI workspace is the complete work area of your organization. In this article, we show you how to create Power BI Workspace with a practical example.

  

Before we start creating Power BI Workspace, let me show you the list of Workspaces that are currently available.

As you can see from the screenshot below, currently, there is only one workspace available for this account. It is the default workplace created by the Power BI service.

How to Create Power BI Workspace

Please click on the Create App Workspace to create a new workspace in Power BI

Create Power BI Workspace 1

Clicking the Create App Workspace opens a new window to define the workspace.

   Create Power BI Workspace 2 Create Power BI Workspace 3 Create Power BI Workspace 4

As you can see from the screenshot below, we assigned the name as Sample Workspace, restricted members to view (no alter). Next, we also added one of my colleagues, John, as this workspace member.

Create Power BI Workspace 5

Clicking save button creates a New workspace in Power BI called Sample Workspace. By default, it opens the following window.

Either you can use this window to get data from different sources, or you can skip this page by clicking the skip button.

Create Power BI Workspace 6

Once you click Skip hyperlink, the following window will display. Use this window to create DashboardsReports, Datasets, and Workbooks.

Create Power BI Workspace 7

We just created one simple dashboard

Create Power BI Workspace 8

Let me show you the reports or tiles inside this dashboard

Create Power BI Workspace 9

The screenshot below shows the Reports inside this Sample Workspace.

Create Power BI Workspace 10

The screenshot below shows you the corresponding dataset. I suggest you to refer Publish reports from Desktop article to publish reports from Power BI desktop.

Create Power BI Workspace 11

 

 

 

 

 

 

Create a Power BI Dashboard

Power BI Dashboard is a collection of reports that explains everything about the business. In this section, we show you how to create a Power BI dashboard with a practical example.

 

Before we start creating Dashboard, let me show you the list of dashboards that are currently available in my Power BI workspace.

As you can see from the screenshot below, currently there are no dashboards available in my workspace.

Create a Power BI Dashboard 1

How to create a Power BI Dashboard

Creating a Dashboard is easy and straightforward. You have to use the + Create button for creating a dashboard inside your workspace.

Create a Power BI Dashboard 2

To create a new dashboard, click the Create button, and then select the Dashboard option from the context menu.

  Create a Power BI Dashboard 3

Selecting the Dashboard option opens a Create dashboard pop-up window. Please specify the dashboard name as per your requirement.

For now, we are assigning the Power BI dashboard name as Sample Dashboard

Create a Power BI Dashboard 4

Now you can see the Sample dashboard under the My Workspace section in the left pane.

Create a Power BI Dashboard 5

Let me navigate to My Workspace. Under the Dashboards tab, you can see the newly created dashboard.

Create a Power BI Dashboard 6

 

 

Power BI Favorites

Power BI Favorites are the same as the Favorites of your Browser. If you find something (report, or a dashboard) interesting, then you can add them to Power BI favorites. By this, you can quickly access them.

  

In this article, we show you the step by step approach to add Reports and dashboards to Power BI Favorites with a practical example. Before we start adding items to Favorites, let me show you the existing Favorites in my workspace.

To view them, please click on the Favorites tab in Power BI Left Navigation Pane. As you can see from the screenshot below, currently, there are no favorites in my workspace.

Add Power BI Favorites 1

Add Dashboard to Power BI Favorites

In this example, we add a dashboard to Power BI favorites. Before we start, let me show you the list of available dashboards.

To view them, please click on the Power BI My Workspace, and then go to the dashboards tab. In this example, we mark the Sixth Dashboard as favorite.

  

Let me click on the dashboard to see the visuals on it.

Add Power BI Favorites 2

From the screenshot below, you can see the visuals available on this dashboard. Click on the Favorite button on Topbar

Add Power BI Favorites 3

As you can see, it has added to the favorite list. Remember, you can click the Unfavorite button to remove this dashboard from the favorite list.

Add Power BI Favorites 4

Let me open my favorite list.

From the below screenshot, you can see the Sixth Dashboard under this section.

Add Power BI Favorites 5

Add Report to Power BI Favorites

In this example, we add Report to Power BI favorites. Let us see the list of available Reports.

To view the reports, please click on the Power BI My Workspace, and then go to the Reports tab. For the demonstration purpose, we mark Basic reports in RPT1 as a favorite.

Please click on the report to see the visuals on it.

Add Power BI Favorites 6

Next, click on the Favorite button on Top bar

Add Power BI Favorites 7

As you can see from the below, the report has added to the favorite list. Remember, click on the Unfavorite button to remove this report from the favorite list. 

 

Add Power BI Favorites 8

Please go to the favorite list to check whether we successfully added or not.

From the screenshot below, you can see the Basic reports in the RPT1 report under this section.

Add Power BI Favorites 9

Remove Power BI Favorites

By clicking that little start, you can remove that item from favorite. For the demo purpose, let me remove the Basic reports in RPT1 from the favorite list.

Add Power BI Favorites 10

Now you see that the report removed

Add Power BI Favorites 11

Add Dashboard to Power BI Favorites – Second Approach

It is a straightforward approach. Please go to the dashboards tab and click on the Star button beside the dashboard that you want to add as a favorite.

Add Power BI Favorites 12

Add Reports to Power BI Favorites – Third Approach

Please go to the Reports tab and click on the Star button beside the report that you want to add as a favorite. Let me add Report 6 to the favorites list

Add Power BI Favorites 13

Now you can see the report 6 as a favorite

Add Power BI Favorites 14