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