Excel Power Query

%3CLINGO-SUB%20id%3D%22lingo-sub-2137529%22%20slang%3D%22en-US%22%3EExcel%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2137529%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20are%20these%20Folders%20that%20automatically%20show%20up%20in%20Power%20Query%20and%20can%20I%20delete%20them%20without%20causing%20any%20harm%20to%20my%20queries%20or%20are%20they%20needed%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22pcull2424_0-1613428178673.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F255086i2D52B459AFCAD61D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22pcull2424_0-1613428178673.png%22%20alt%3D%22pcull2424_0-1613428178673.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2137529%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2138449%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2138449%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F967592%22%20target%3D%22_blank%22%3E%40pcull2424%3C%2FA%3E%26nbsp%3BIt%20seems%20you%20are%20querying%20%22From%20a%20folder%22%20four%20times.%20PQ%20automatically%20creates%20the%20helper%20queries%2C%20parameters%2C%20a%20sample%20file%20and%20a%20function%20to%20transform%20the%20sample%20file%20in%20order%20to%20make%20it%20all%20work.%20So%2C%20NO!%20you%20can't%20just%20delete%20them.%20But%2C%20I%20notice%20the%20yellow%20triangles%20in%20the%20two%20helper%20folders%20that%20you%20opened%20up%20(both%20called%20Transform%20file%20from%20WINFELD....).%20These%20indicate%20that%20there%20is%20some%20kind%20of%20error.%20PQ%20can't%20find%20the%20file(s)%20in%20the%20folder%20it's%20looking%2C%20or%20perhaps%20the%20folder%20no%20longer%20exists.%20Can't%20tell.%20You%20have%20a%20third%20set%20of%20helper%20queries%20that%20seem%20to%20look%20at%20the%20same%20folder.%20If%20so%2C%20and%20if%20that%20one%20shows%20no%20errors%2C%20you%20can%20probably%20delete%20the%20ones%20with%20errors.%20Again%2C%20can't%20tell%20for%20sure.%20Save%20your%20work%20first%20and%20create%20a%20copy%20of%20the%20file.%20Open%20the%20copy%2C%20delete%20the%20first%20two%20query%20groups%20and%20see%20what%20happens.%20If%20you%20end%20up%20with%20more%20errors%2C%20don't%20save.%20Just%20close%20and%20re-open%20your%20previously%20saved%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2148085%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2148085%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThank%20you%20very%20much%20for%20the%20information!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

What are these Folders that automatically show up in Power Query and can I delete them without causing any harm to my queries or are they needed? 

 

pcull2424_0-1613428178673.png

 

 

 

2 Replies

@pcull2424 It seems you are querying "From a folder" four times. PQ automatically creates the helper queries, parameters, a sample file and a function to transform the sample file in order to make it all work. So, NO! you can't just delete them. But, I notice the yellow triangles in the two helper folders that you opened up (both called Transform file from WINFELD....). These indicate that there is some kind of error. PQ can't find the file(s) in the folder it's looking, or perhaps the folder no longer exists. Can't tell. You have a third set of helper queries that seem to look at the same folder. If so, and if that one shows no errors, you can probably delete the ones with errors. Again, can't tell for sure. Save your work first and create a copy of the file. Open the copy, delete the first two query groups and see what happens. If you end up with more errors, don't save. Just close and re-open your previously saved workbook.

@Riny_van_Eekelen Thank you very much for the information!