I added data from different files by using power query on 3 excel files. I have set the formula to select only the excel files from a particular folder. When i created the query, i tried adding an extra file & refreshed the data, everything was flowing in. But once i saved & closed the file having the merged data, i added another file to recheck if the merged data was working. Now when i open the file & use refresh option, the new file data is not getting added to my existing query with error as Data not downloaded or File is in use.
