Forum Discussion
power querry doesnt read all files
You need to do this adjustment in the Transform Sample File step. Since Power BI hardcodes the Sheet name of the sample file you selected it will look for the same sheet name in the rest of the files. Better replace it with the Index of the sheet.
All the sheet names are different becouse it is used by sales reps to track new customers tht theyhave brought in. The column names are the same on every sheet, and the files are the same type. First when I start combining them it shows all the sheets but when I filter the data for the column the problem occurs.
You need to do this adjustment in the Transform Sample File step. Since Power BI hardcodes the Sheet name of the sample file you selected it will look for the same sheet name in the rest of the files. Better replace it with the Index of the sheet.