Locked lesson.
About this lesson
Learn how to create a dashboard based off of report data.
Exercise files
Download this lesson’s related exercise files.
6.04 create-reports-and-dashboards-with-power-bi---part-3 - Exercise.docx53.9 KB 6.04 create-reports-and-dashboards-with-power-bi---part-3 - Exercise solution.docx
125.1 KB
Quick reference
Create Reports and Dashboards with Power BI: Part 2
Publish a Power BI Report to the Power BI service to make it accessible to others and create a dashboard to display key metrics.
When to use
We publish our Power BI report to the Power BI service whenever we want others to be able to view the report. We create a dashboard to present key metrics from across our report pages to gain insight.
Instructions
Let's make some final changes to our report before publishing it to the Power BI Service.
Change Text
We can change any text on our report pages. Text is contained within text boxes, and much like other Microsoft applications, we can click in the text box to make formatting changes.
In Power BI, a floating text formatting toolbar will appear and we can use this to change the font style, font size, font color, etc.
Format Visualizations
We can use the Format visual tab in the Visualizations pane to change the look and feel of our charts, graphs, tables, and cards. Each element is customizable. We can change the colors, the format of text, the way text is displayed and laid out, and other design elements.
Some visualizations, like tables, have preset styles we can choose to quickly change the look.
Update Project Report
Project data usually does not stay static. If a project is in progress, tasks will constantly be updated and new tasks might be added. We need to make sure we keep our report up to date with the latest changes so it doesn't fall out of sync.
- Make the changes in Project for the Web.
- Open the report in Power BI.
- From the Home tab, in the Queries group, click Refresh.
Publish to the Power BI Service
Once we've created our report, we can share it with others by publishing it to the Power BI Service. Before we publish, we need to set up a workspace to publish it to the Power BI Service.
- Open Power BI from Microsoft 365.
- In the left-hand menu, click Workspaces.
- Click Create a workspace.
- Give the workspace a name.
- Add a Description (optional).
- Click Save.
The new workspace will store not only the report, but the report data and any dashboards we create.
- Go back to Power BI Desktop.
- Click Publish.
- Save the changes if required.
- Choose the workspace from the list.
- Click Select.
The report will now be published to the Power BI Service.
Create a Dashboard
A dashboard is a way to present key metrics, the data our audience is most interested in. We can choose visualizations from any of our report pages and pin them to the dashboard.
- Go to Power BI in Microsoft 365.
- From the left-hand menu, open the report from the workspace.
- Hover the mouse over any visualization.
- Click the pin icon to pin it to the dashboard.
- Repeat this process for each visual you want to pin.
To go to the dashboard, click on the name in the Dashboard section of the left-hand pane.
Hints & tips
- Power BI files save with a .pbix file extension.
Lesson notes are only available for subscribers.