Upload Excel Files to Power BI Dashboard

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 Power BI dashboard.

How to upload Excel Files to Power BI Dashboard

By default, when you open your Power BI 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.

Upload Excel Files to Power BI Dashboard 1

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.

Upload Excel Files to Power BI Dashboard 2

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.

Upload Excel Files to Power BI Dashboard 3

Next, Power Bi provides two options for you

  • Import Excel data into Power BI: It allows you to design reports using this imported excel file.
  • Upload your Excel files to Power BI: This is the same as Excel Online. You can view, interact with the data like you normally do in Excel. No reporting. I suggest you refer to the Upload Power BI Workbooks article to understand this option.

Let me select the Import Excel data into Power BI option

Upload Excel Files to Power BI Dashboard 4

Please wait until the importing is complete

Upload Excel Files to Power BI Dashboard 5

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.

Upload Excel Files to Power BI Dashboard 7

TIP : I suggest you to refer Create a report using Excel Data article to understand the usage of Excel Sheets