Книга: Power BI: 3 in 1- Comprehensive Guide of Tips and Tricks to Learn the Functions of Power BI+ Simple and Effective Strategies+ Advanced Guide to Learn the Advanced Realms of Power BI
Назад: Dynamic Row Level Security in Power BI
Дальше: Power BI and Share Point

 

 

In this chapter, we will discuss the Bookmarks in Power Bi Desktop, how to implement the Toggle button with the Bookmark feature, and how to implement report Tooltip in Power BI desktop.

Metrics to be Displayed in the Report

  1. To Display gross profit by year
  2. To Display gross profit by country
  3. To Display gross profit by product type
  4. To Display revenue, planned revenue and gross profit by year in Tabular format
  5. To Display revenue, planned revenue and gross profit by product type in Tabular format

1. To Display gross profit by year

2. To Display gross profit by country

3. To Display gross profit by product type

4. To Display revenue, planned revenue and gross profit by year in Tabular format

5. To Display revenue, planned revenue and gross profit by product type in Tabular format

Use Case : The customer wants to display different views on a page when you click on a button and show multiple metrics on a single tile.

Feature Requirements:

  1. Toggle between different visuals in a single page
  2. Report Page Tooltip

Create Bookmark in Power BI Desktop

Note: To implement Report tooltip feature in Power BI Desktop install March 2018 (2.56) or later versions.

Microsoft Power BI is a reporting tool that is used for data visualization. It can connect to different data sources, produce reports, and publish them for various organizations. It brings data to life with complete visualization. This section provides detailed steps for publishing the reports/dashboard for the members of various organizations or specific individuals using the Apps Workspace. 

For the benefit of the organization, we have tested the scenario and attached the screenshots of the sample data and the dashboard that comes in the app once it is published. This can be a potential use case to share the reports like monthly profit dashboards, quarterly results of the company, etc. with identified stakeholders.

 

Apps Workspace will act as a placeholder for published dashboards and reports. Apps are bound to App Workspace; that is, before you create an app, you have to have an app workspace. App Workspace is fairly similar to a group workspace.

Creating Apps

Step 1: To Create the App Workspace, click on Create app workspace.

Step 2: Fill in the details for creating the apps workspace. You can add members to this workspace.

Private: Only approved members of the workspace can view the app.

Public: All members of the organization can view the app.

Members can be granted permission:

  1. View: Members can only view Power BI Content
  2. Edit: Members can edit Power BI Content

Step 3: Go to your Power BI Desktop Version and publish the report to Power BI Service.

Step 4: Select the destination to be published to:

Visit the report published by Power BI desktop in the Power BI Service and pin this report to the dashboard.

Publishing App

Go to Workspace -> The app workspace you created -> Click on Dashboards

Click on Publish App.

This will take you through certain steps:

  1. Fill in Details, Content, and Access
  2. And click on Finish to end publishing the app

This is the App Icon generated through App Workspace. On clicking the app icon user can view the dashboard.

The end-user/business user can install the app from Microsoft AppSource, or the admin/creator of the app can directly send the URL link to the app.

Updating the App

For any changes made to the dashboards in the Apps Workspace. The app needs to be updated.

  1. Modify the dashboard: You will have edit report option on the top of the report to make any changes
  2. In the app workspace, you will find the update app option.
  3. Update all the options: Details, Content, and Access.
  4. Click on Update App.

Unpublish the App

For unpublishing the app, you can click on the option Unpublish App . Below is the snapshot for the same.

Note:

Let us understand in detail how to source an existing Power BI report into a new Power BI report. If there is a requirement of creating a new Power BI reports by making use of the existing set of the report, then Power BI provides an option to do this. With this option, the effort of recreating the data model, and the process of data refresh multiple times is eliminated.

The steps are explained below in detail.

Step 1: Open a new Power BI desktop file and log in using your Microsoft account.

Step 2: In the navigation bar under ‘Get Data,’ select ‘Power BI datasets.’ This connects to the workspace created in the Power BI server.

Step 3: Select the required report from the workspace and click on ‘Load.’

Step 4: This step adds all the tables which are available in the existing power BI report to the newly created report. These tables are available on the right-hand side of the report. And at the bottom right corner, there is a message displayed saying that the report is connected live to Power BI dataset, report name, and the workspace name.

Step 5: This newly created file can then be used to create the required visualizations for analysis.

 

 

Advantages

Limitations

Назад: Dynamic Row Level Security in Power BI
Дальше: Power BI and Share Point