Create a Power BI dashboard from a report
You've read Dashboards in Power BI, and now you want to create your own. There are many different ways to create a dashboard - from a report, from scratch, from a dataset, by duplicating an existing dashboard, and more. This topic and video show you how to create a new dashboard by pinning visualizations from an existing report.
NOTE: Dashboards are a feature of Power BI service, not Power BI Desktop. Dashboards can't be created in Power BI mobile, but they can be viewed and shared.
Video: Create a dashboard by pinning visuals and images from a report
Watch Amanda create a new dashboard by pinning visualizations from a report. Then try it out yourself, using the Procurement Analysis sample, by following the steps below the video.
Import a dataset with a report
We'll import one of the Power BI sample datasets and use it to create our new dashboard. The sample we'll use is an Excel workbook with two PowerView sheets. When Power BI imports the workbook it will add a dataset and also a report to your workspace. The report is automatically created from the PowerView sheets.
- Select this link to download and save the Procurement Analysis sample Excel file. We recommend saving it in your OneDrive for Business.
- Open Power BI service in your browser (app.powerbi.com).
- Select an existing workspace or create a new app workspace.
From the left nav, select Get Data.
Navigate to the location where you saved the Procurement Analysis sample Excel file. Select it and choose Connect.
For this exercise, select Import.
When the Success message appears, select the x to close it.
Open the report and pin some tiles to a dashboard
Staying in the same workspace, select the Reports tab. The newly-imported report displays with a yellow asterisk. Select the report name to open it.
The report opens in Reading view. Notice it has two tabs at the bottom: Discount Analysis and Spend Overview. Each tab represents a page of the report.
Hover over a visualization to reveal the options available. To add a visualization to a dashboard, select the pin icon.
Since we're creating a new dashboard, select the option for New dashboard and give it a name.
When you select Pin, Power BI creates the new dashboard in the current workspace. When the Pinned to dashboard message appears, select Go to dashboard. If you're prompted to save the report, choose Save.
Power BI opens the new dashboard and there is one tile - the visualization we just pinned.
To return to the report, select the tile. Pin a few more tiles to the new dashboard. This time when the Pin to dashboard window displays, select Existing dashboard.
Congratulations on creating your first dashboard! Now that you have a dashboard, there's so much more you can do with it. Try one of the suggested Next steps below, or start playing and exploring on your own.
- Resize and move tiles
- All about dashboard tiles
- Share your dashboard by creating an app
- Power BI - Basic Concepts
- Dashboards in Power BI
- Tips for designing a great dashboard
More questions? Try the Power BI Community