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 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.

Select Files under Workspace Get Data Tab 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.

Choose Local File option 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: 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

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