Forum Discussion
Helper IVImporting 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:
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
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?
Advocate IDid 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...
I agree that this is not a solution, is there anything that can be done to get this resolved?
Let's say I want to extract 1 table from an enormous excel workbook. Why do I see Power Query processing each and every sheet in that file in the bottom right-hand corner?