power querry doesnt read all files

[Anonymous]

Hi I have an excel file wich should read data from 14 files, each file has 5-10 sheets.

I only need data from 1 collumn which are dates, i have protected the column so only dates can be input.

But the power querry doesnt read a few 4-5 sheets and 1 whole file. 

What could be the problem?

[v-achippa]

Hi @Anonymous,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @ray_aramburo for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @schakos1,

We wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @schakos1,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[Omid_Motamedise]

What is your query?

[Anonymous]

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.

[ray_aramburo · Accepted solution]

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.

[ray_aramburo]

Check if the Sheet names are the same, check if the column names are the same and if the other file meets the requirements you defined prior/when combining the files.