In Power BI, a dashboard is a single page that displays visualizations, reports, and datasets in a structured way. To upload data to a dashboard, you first need to upload your Excel file as a workbook in Power BI. After uploading, you can pin the Excel data to an existing dashboard or create a new dashboard for it.
Steps to Upload Excel Files to Dashboard
Prerequisite:
A dataset is required, Click here to Download used Excel data.
Step 1: Open Power BI Service. Click on Workspace.
Step 2: You will see the following interface. Now click on My Workspace.
Step 3: First, upload your Excel file. Hover over Upload.
Step 4: Now click on Browse.
Step 5: Select the Excel file from your computer. If you want to use the sample data, you can download it using the link above. Otherwise, select your own Excel data to continue.
Step 6: You will now see your Excel data uploaded to My Workspace.
Step 7: Now Click on Uploaded Excel Workbook.
Step 8: It will show the following interface.
Step 9: To make this data part of a dashboard, select the Excel data.
Step 10: Click on the Pin icon on the upper right side.
Step 11: Enter the name of the dashboard. You can choose to pin it to an existing dashboard or create a new dashboard. In this example, we will create a new dashboard by entering a new name. Then click Pin.
Step 12: Your dashboard with the Excel data is now created and visible under My Workspace. To verify, click on the dashboard name you just created (for example, ExcelToDash).
Step 13: We can see now our excel data is on the Dashboard page.
