Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

power querry doesnt read all files

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. B...
Need Help
  • ray_aramburo's avatar
    ray_aramburo
    1 year ago

    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.

v-achippa's avatar
v-achippa
Community Support
1 year ago

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's avatar
v-achippa
Community Support
1 year ago

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