Forum Discussion
Helper IVImporting 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.
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:
Open the query editor, right-click on queries and cancel the “Enable load”:
Click “Close & Apply”, the table which you cancel the load will disappear:
Regards,
Xiaoxin Sheng
9 Replies
aktripathi2506That 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.
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.
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.
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?
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:
Open the query editor, right-click on queries and cancel the “Enable load”:
Click “Close & Apply”, the table which you cancel the load will disappear:
Regards,
Xiaoxin Sheng
