How to upload Excel Files to Power BI Dashboard with a practical example?. To demonstrate the Upload Excel Files to Power BI Dashboard, we load data from the Global store excel workbook to the dashboard.
How to upload Excel Files to Power BI Dashboard
By default, when you open your service URL, it displays the following page. If this is not the case, then click on the Get Data button on the bottom left corner.
In this example, we want to upload an excel file to the Power BI dashboard. So, let me click on the Get button inside the Files Tile.
Clicking the Get button opens the following window. In this Power BI example, we want to upload an Excel file from the local hard drive. So, let me select the Local Files option.
Once you click on the Local Files button, a new window opened to select the File from your file system. For now, we are selecting the Global Store Excel workbook, as shown below.
Next, Power Bi provides two options for you
- Import Excel data: It allows you to design reports using this imported excel file.
- Upload your Excel files: This is the same as Excel Online. You can view, and interact with the data like you normally do in Excel. No reporting. I suggest you refer to the Upload Workbooks article to understand this option.
Let me select the Import Excel data into Power BI option
Please wait until the importing is complete
Let me navigate to My Workspace -> Datasets tab to see the available datasets. As you can see, it is displaying the Global Store Dataset that we created earlier.
TIP : I suggest you to refer Create a report using Excel Data article to understand the usage of Excel Sheets