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
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 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.