Skip to main content
Power BIPowerBI tutorials

Pin workbooks to the Power BI dashboard

Let me show you the step-by-step approach to pinning workbooks to the Power BI dashboard with a practical example. Before I start pinning the workbooks, let me show you the list of workbooks in my Power BI workspace.

As you can see in the screenshot below, there is only one workbook. I suggest you refer to the Upload workbooks article to understand the process of uploading this file to Power BI.

pin-workbooks-to-power-bi-dashboard-1-4959296

Pin workbooks to the Power BI dashboard

In this example of Pinning Workbooks to the Power BI Dashboard, we are going to use this Workbook. Click on this report to view the data within this workbook.

pin-workbooks-to-power-bi-dashboard-2-9352934

You can see what Excel shows online. You can anchor this data by using the cursor to select the required Rows and Columns.

pin-workbooks-to-power-bi-dashboard-3-9785498

Let me select the first 15 rows and 8 columns. Then click the Pin button to pin them to the dashboard.

pin-workbooks-to-power-bi-dashboard-4-7336335

Clicking on that Pin button opens the following window.

  1. Existing control panel: Select this option to add this data to an existing dashboard.
  2. New dashboard: Select this option to create a new dashboard for the data in this workbook.

Let me select the Existing Panel option and then select Fifth Panel.

pin-workbooks-to-power-bi-dashboard-5-3762727

Inside the fifth panel, you can see the data from the Excel workbook that we selected and pinned earlier.

pin-workbooks-to-power-bi-dashboard-6-8131775
error: Attention: Protected content.