Importing data from Folder using power query

[earthworm]

When I am trying to import data from Folder from multiple workbooks i have noticed that power query only imports single sheet and not another sheets in a same workbook. Please help.

 

[johnny51981]

You have to treat each sheet/tab as a unique data connection. Example, you have HR INFO.xlsx with "Employee" and "Salary" sheets.

You would need to set up a connection to HR INFO.xlsx - Employee and HR INFO.xlsx - Salary

 

[GraH]

You probably used the navigator and selected a sheet. Instead select the folder above. This folder represents the workbook.