In this article, we will show you, How to upload Excel Files to Power BI Dashboard with practical example. To demonstrate the same, we will load data from Global store excel workbook to Power BI dashboard.
How to upload Excel Files to Power BI Dashboard
By default, when you open your Power BI service URL, it will display the following page. If this is not the case, then click on the Get Data button on bottom left corner.
In this example we want to upload excel file so, let me click on the Get button inside the Files Tile
Clicking the Get button will open the following window. In this example, we want to upload Excel file from local hard drive. So, let me select the Local Files option
Once you click on the Local Files button, a new window will be 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 will provide two options for you
- Import Excel data into Power BI: This will allow you to design reports using this imported excel file.
- Upload your Excel files to Power BI: This is same as Excel Online. You can view, interact with the data like you normally do in Excel. No reporting. I suggest you to refer Upload Power BI Workbooks article to under 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
Thank You for Visiting Our Blog