In this article, we show you how to load Power BI workbooks with a practical example. To demonstrate Power BI workbook loading, we loaded the global store sample workbook into the Power BI dashboard.
Before I start uploading, let me show you the list of workbooks that are currently available in my Power BI workspace.
As you can see from the following screenshot, there are currently no workbooks available in my workspace.
<>How to upload Power BI workbooks
To upload workbooks to Power BI, click the Get information button in the lower left corner.
In this example, we want to load an Excel workbook. So let me click on the Obtain inside the Power BI file archive.
By clicking on the Obtain The button opens the following window. In this example, we want to load an Excel workbook from our local file system. So, let me select the Local files option
Once you click on the Local files , a new window opens to select the file from your file system. For now, we are selecting the Global Store sample Excel workbook as shown below
Then Power BI offers you two options
- Import data from Excel to Power BI: It allows you to design reports using this imported Excel file. This option adds Dataset to my workspace. I suggest you refer to the article Upload Excel File.
- Upload your Excel files to Power BI: This is the same as Excel Online. You can view and interact with the data as you normally do in Excel. This option adds the Workbook to my workspace.
Let me select the Upload your Excel files to Power BI option
Please wait until the upload is complete
Let me navigate to My Workspace -> Workbooks tab to see the available workbooks. As you can see, it shows the sample workbooks from the global store that we loaded earlier.
