Excel Power Query : Data not refreshing on Merged Data from more than 2 files

%3CLINGO-SUB%20id%3D%22lingo-sub-1503831%22%20slang%3D%22en-US%22%3EExcel%20Power%20Query%20%3A%20Data%20not%20refreshing%20on%20Merged%20Data%20from%20more%20than%202%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1503831%22%20slang%3D%22en-US%22%3E%3CP%3EI%20added%20data%20from%20different%20files%20by%20using%20power%20query%20on%203%20excel%20files.%20I%20have%20set%20the%20formula%20to%20select%20only%20the%20excel%20files%20from%20a%20particular%20folder.%20When%20i%20created%20the%20query%2C%20i%20tried%20adding%20an%20extra%20file%20%26amp%3B%20refreshed%20the%20data%2C%20everything%20was%20flowing%20in.%20But%20once%20i%20saved%20%26amp%3B%20closed%20the%20file%20having%20the%20merged%20data%2C%20i%20added%20another%20file%20to%20recheck%20if%20the%20merged%20data%20was%20working.%20Now%20when%20i%20open%20the%20file%20%26amp%3B%20use%20refresh%20option%2C%20the%20new%20file%20data%20is%20not%20getting%20added%20to%20my%20existing%20query%20with%20error%20as%20Data%20not%20downloaded%20or%20File%20is%20in%20use.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1503831%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1504051%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Power%20Query%20%3A%20Data%20not%20refreshing%20on%20Merged%20Data%20from%20more%20than%202%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1504051%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F717832%22%20target%3D%22_blank%22%3E%40SmithnSmith%3C%2FA%3E%26nbsp%3BCan%20you%20give%20access%20of%20Anydesk%20and%20show%20the%20error%20what%20actually%20you%20are%20facing%20and%26nbsp%3B%20we%20will%20surely%20try%20to%20find%20a%20solution%20for%20your%20problem%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20tell%20me%20when%20you%20are%20online%20and%20connect%20with%20me%20on%20my%20Mail%20id%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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.

1 Reply
Highlighted

@SmithnSmith Can you give access of Anydesk and show the error what actually you are facing and  we will surely try to find a solution for your problem .

 

Just tell me when you are online and connect with me on my Mail id