SOLVED

Power Query Append Error

%3CLINGO-SUB%20id%3D%22lingo-sub-1863323%22%20slang%3D%22en-US%22%3EPower%20Query%20Append%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1863323%22%20slang%3D%22en-US%22%3E%3CP%3ENeeding%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20new%20to%20power%20query%20and%20I'm%20importing%20table%20information%20in%20from%20an%20appended%20query%20from%20another%20spreadsheet.%26nbsp%3B%20I%20have%2026%20columns%20that%20are%20visual%20in%20my%20appended%20sheet%20that%20I%20am%20importing%20from.%26nbsp%3B%20However%20when%20I%20connect%20the%20table%20and%20import%20the%20data%2C%20I%20automatically%20receive%20many%20more%20columns%20that%20I%20don't%20want.%26nbsp%3B%20How%20can%20I%20make%20these%20columns%20go%20away%20and%20stay%20away%20when%20I%20add%20new%20columns%20in%20my%20source%20data%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1863323%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1863851%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20Append%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1863851%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F860707%22%20target%3D%22_blank%22%3E%40pcman24%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20automate%20that%20if%20there%20is%20a%20formal%20logic%20which%20columns%20to%20keep.%20That%20could%20be%20names%20of%20the%20columns%2C%20or%20name%20of%20the%20last%20column%2C%20or%20number%20of%20columns%2C%20or%20keep%20all%20non-blank%20columns%2C%20or%20something%20else.%20Concrete%20implementation%20depends%20on%20such%20logic%2C%20but%20it's%20better%20to%20discuss%20having%20sample%20file%20in%20place.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Visitor

Needing help!

 

I'm new to power query and I'm importing table information in from an appended query from another spreadsheet.  I have 26 columns that are visual in my appended sheet that I am importing from.  However when I connect the table and import the data, I automatically receive many more columns that I don't want.  How can I make these columns go away and stay away when I add new columns in my source data? 

 

Thank you!

 

1 Reply
Best Response confirmed by pcman24 (Regular Visitor)
Solution

@pcman24 

You may automate that if there is a formal logic which columns to keep. That could be names of the columns, or name of the last column, or number of columns, or keep all non-blank columns, or something else. Concrete implementation depends on such logic, but it's better to discuss having sample file in place.