cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

Importing excel worksheet among multiple worksheets

Hi,

 

I am having a doubt:

Suppose I have an excel which have 4-5 tabs (Worksheet) with data in it, but I want to import only 1 sheet. Then when I upload the data in query editor I see the other workbooks name as well in the bottom right corner (while processing in query editor). Is power BI spent some time in looking into other worksheet too which are the part of the file (but not needed for our report).

 

I think it makes my data load slow.

If it does then any idea to avoid this and make the process faster

 

Any opinion, Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Importing excel worksheet among multiple worksheets

Hi @aktripathi2506,

 

According to your description, you want to choose which sheet to load when you Importing excel worksheet, right?

If it is a case, you can use query editor to achieve your requirement.

 

Steps:


I have three tables which import from excel workbook:

Capture4.PNG
 

Open the query editor, right-click on queries and cancel the “Enable load”:

Capture5.PNG
 

Click “Close & Apply”, the table which you cancel the load will disappear:

Capture6.PNG
 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

8 REPLIES 8
KHorseman Super Contributor
Super Contributor

Re: Importing excel worksheet among multiple worksheets

If you don't need to import an entire ready-made data model from your excel sheet, but rather only need to load a table that's on one sheet, use the query editor to load it instead of importing the file. Get Data > Excel


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!

Re: Importing excel worksheet among multiple worksheets

That is the way I import the worksheet from report view (Get data --> excel) is there any other way?

When I make any changes in query mode and then when I referesh, it also look into other worksheets.

 

For example I am having an excel filte with 4 work sheets (Sheet 1, Sheet 2, Sheet 3, Sheet 4)

But I need only one worksheet (say sheet 1)

I import this file by using get data then selecting excel.

 

But when I do changes in query mode and referesh the data source I also see the names of sheet 3 and sheet 4 although I havn't imported them.

KHorseman Super Contributor
Super Contributor

Re: Importing excel worksheet among multiple worksheets

It sounds like you have accidentally loaded the other sheets without realizing it. Perhaps you checked multiple sheets when you first tried to connect to the workbook. I just did a test against a workbook with two sheets and it only loads the one that I checked.


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
Community Support Team
Community Support Team

Re: Importing excel worksheet among multiple worksheets

Hi @aktripathi2506,

 

According to your description, you want to choose which sheet to load when you Importing excel worksheet, right?

If it is a case, you can use query editor to achieve your requirement.

 

Steps:


I have three tables which import from excel workbook:

Capture4.PNG
 

Open the query editor, right-click on queries and cancel the “Enable load”:

Capture5.PNG
 

Click “Close & Apply”, the table which you cancel the load will disappear:

Capture6.PNG
 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

Wlandim Frequent Visitor
Frequent Visitor

Re: Importing excel worksheet among multiple worksheets

Did you find the solution?

I have the same issue, but with a lot of worksheets, every time I need to refresh I have 365 worksheets with 4 sheet that is a lot of processing.

I tryed many workarounds but power query reads all the four sheets of each worksheet before filtering my sheet of interest.

Wlandim Frequent Visitor
Frequent Visitor

Re: Importing excel worksheet among multiple worksheets

Did you find the solution for excel case?

I have the same issue, but with a lot of worksheets, every time I need to refresh I have 365 worksheets with 4 sheet that is a lot of processing.

I tryed many workarounds but power query reads all the four sheets of each worksheet before filtering my sheet of interest.

Yarroo Frequent Visitor
Frequent Visitor

Re: Importing excel worksheet among multiple worksheets

Does anyone have a solution for that problem? The accepted reply is not the answer to the question in my view (I have the same problem), it is not how to skip certain query from loading / refreshing, but how to make sure only single sheet is downloaded when reading from workbook containing multiple sheets.

 

I used edit query and if I select e.g. "Sheet1" in "Navigation" step, I still see Power BI "reads through" other sheets in this workbook, including some with "$". I think it slows down the refresh massively. What am I doing wrong?

joannab Frequent Visitor
Frequent Visitor

Re: Importing excel worksheet among multiple worksheets

Did you find the solution? I have exactly the same issue and agree, that accepted answer in this thread is not the solution for that particular issue...

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)