Forum Discussion

Simon_29's avatar
Simon_29
Helper II
4 years ago
Solved

problem with Power Query updating new data from named file

Hello, I have a problem with Power Query updating new data. I found a function that works by typing the name and path of the folder I want to load into Power Query into a cell in Excel. I created ...
Need Help
Show and Tell
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Simon_29 

     

    Agree with AlexisOlson that M language is case-sensitive, which is the cause. The values in this step should be consistent with the values in Item and Kind columns. 

     

    As it is using Excel.Workbook() to extract the file, the names in Item column with "Sheet" kind are from the Sheet names in the Excel file, not the name of the Excel file. If you want to use your function, you need to keep the sheet name in the Excel file identical with the file name. 

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Simon_29 

 

Agree with AlexisOlson that M language is case-sensitive, which is the cause. The values in this step should be consistent with the values in Item and Kind columns. 

 

As it is using Excel.Workbook() to extract the file, the names in Item column with "Sheet" kind are from the Sheet names in the Excel file, not the name of the Excel file. If you want to use your function, you need to keep the sheet name in the Excel file identical with the file name. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.