Forum Discussion
Folder Data Refresh
Hi JamesLow ,
When you load the latest file into power query, the number of colums has been wriiten into the function so that you can only see the new data when adding rows data. However, if you add new columns data into the file, you need to change the column number of the function in power query as you needed:
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
If the structure of the CSV files (including the column headers) has changed - it's likely that your Power Query needs to be updated/adjusted - as it tends to use a 'fixed' range for CSV files. For example - if your original CSV file had 30 columns - that "30" is hardcoded in the import. So if your new files have 35 columns - the last 5 will be missing until you adjust the scope.
Additionally - column headers are fundamental to have Power Query looks for and grabs info. It's not clear how much your headers are being used during the import - as it doesn't appear that it's breaking - so you may want to go into those steps to see what's happening to your new headers when compared to the old ones.
This will likely all be solved by examining the query editor steps used for this import.