How to Add Reports to Dashboard in Power BI
Power BI allows you to create interactive reports and dashboards with your data. You can easily add reports to a dashboard to provide a consolidated view of your key metrics. Here’s a step-by-step guide on how to add reports to a dashboard in Power BI:
- Open your Power BI workspace and navigate to the desired report.
- Click on the “Pin Live Page” button located on the top toolbar.
- A dialog box will appear showing you a preview of the report page. You can reposition and resize the preview as needed.
- Select the desired dashboard from the drop-down menu. If you don’t have any existing dashboards, you can create a new one by clicking on the “+ New dashboard” button.
- Click on the “Pin Live” button to add the report to the selected dashboard.
- The report will now appear as a tile on your dashboard. You can rearrange and resize the tiles to create a visually appealing layout.
- To interact with a report on the dashboard, simply click on its tile. The report will open in a new tab, allowing you to explore the data in more detail.
- You can also set up automatic data refresh for the report on the dashboard by configuring the dataset’s refresh settings.
Example:
Let’s say you have a sales report that you want to add to a dashboard. You can follow the steps below:
- Open Power BI and navigate to the sales report.
- Click on the “Pin Live Page” button.
- Resize and reposition the preview to your liking.
- Select the desired dashboard from the drop-down menu or create a new one.
- Click on the “Pin Live” button.
- The sales report will now appear as a tile on your dashboard.
- You can further customize the tile by changing its size and position.
- Clicking on the tile will open the sales report in a new tab for further analysis.
By following these steps, you can add multiple reports to your dashboard and create a consolidated view of your data.