Power BI Provides a function to upload excel data into Dashboard form. The dashboard in Power BI is a single page that shows all data and visualization of reports, and datasets in a specific structure way. For Uploading data in Dashboard first have to upload our excel file in the workbook and then we can pin this excel data to the created dashboard or we can also create a new dashboard.
Steps to Upload Excel Files to Dashboard
A dataset is required, Click here to Download used Excel data.
Step 1: Open Power BI Service. Click on Workspace.
Step 2: The following interface will show. now click on My Workspace.
Step 3: First we need to upload our excel file so hover on Upload.
Step 4: Now click on Browse.
Step 5: Next Select data from your Computer. If you want to use the same data then before the steps there is a link for downloading this excel data. If you want to go with your excel data then you can continue.
Step 6: Now we can see our excel data is uploaded in My Workspace.
Step 7: Now Click on Uploaded Excel Workbook.
Step 8: It will show the following interface.
Step 9: For Making this data a Dashboard, select Excel data.
Step 10: Next Click on the upper right side icon Pin.
Step 11: Next We need to enter the dashboard name. There are two options Existing dashboard and the New dashboard. We are entering a New dashboard name. You can select based on your choice. After entering the dashboard name, Click on Pin.
Step 12: Now Our dashboard of excel data is created and we can see it in our My Workspace. For checking Click on ExcelToDash or what dashboard you created.
Step 13: We can see now our excel data is on the Dashboard page.