My data read from a folder. Everyday I will put in a new file into the folder and when click refresh it will refresh all file in the folder which is time consuming. Can we have an option to "refresh ...
This is a must have function. Power query pulls data from 70 Excel files save by business units (BUs). That data is review by management. Some BUs may be required to modify data in their files. Power query needs to incorporate data from all files, but needs to refresh only for modified files. This would be a great time saver.
