Upload Excel Files to Power BI Dashboard

How to upload Excel Files to Power BI Dashboard with a practical example? To demonstrate this, 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.

Choose the Excel File from local hard drive 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

Wait until importing xls or xlsx file 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

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.