In this article, we will show you, How to connect Power BI to Multiple Excel Sheets, and how to use data present in those Excel sheets.
To demonstrate the Connect Power BI to Multiple Excel Sheets, we will load data from multiple tables or sheets in an excel file to Power BI, and generate a bar chart.
How to Connect Power BI to Multiple Excel Sheets
Before we get started, Let us see the data present in the Sample superstore Excel File. From the below screenshot, you can see, it has three sheets Orders, Returns, and Users
If you are in the Power BI visualization page. Under the Home tab, Click the Get Data option and select the Excel as we shown below. Or, select More option and select Excel
Once you click on the Excel tab, a new window will open to select the Excel File from our file system. For now, we are selecting the Sample – Superstore file as shown below
Expanding the Superstore Excel folder will display the list of available sheets.
Selecting the sheet or table will show the Data Preview. From the below screenshot, you can see the preview of the sheet. If you are satisfied with the Data and the data types then click Load button otherwise, click Edit button to make changes.
Currently, we don’t want to make any changes to the data. So, let me click on the Load button
Please wait until the load is complete
Now you can see all the Columns imported from the excel file under the Fields section. As you can see, there is an issue with the Users table because Power BI hasn’t picked up the column names from the first row.
Please click on the Edit Queries tab
Click on the Use First Row as Headers
That’s it. We loaded data from multiple sheets.
Let me create a Column chart using this data. I suggest you refer, Column Chart in Power BI article to understand the steps involved in creating it.
Thank You for Visiting Our Blog