Home

Power Query Loads Table With Additional Blank Column

%3CLINGO-SUB%20id%3D%22lingo-sub-695872%22%20slang%3D%22en-US%22%3EPower%20Query%20Loads%20Table%20With%20Additional%20Blank%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-695872%22%20slang%3D%22en-US%22%3E%3CP%3EEvery%20time%20I%20initially%20load%20Power%20Query%20output%20to%20a%20worksheet%20the%20table%20is%20always%20loaded%20with%20an%20additional%20column%20that%20is%20not%20in%20my%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20if%20the%20query%20I%20build%20has%20a%20table%20with%205%20columns%20when%20I%20click%20Close%20and%20Load%20for%20the%20first%20time%20the%20output%20has%206%20columns%20where%20the%20added%20column%20is%20blank%20and%20labeled%20%22Column%201%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20believe%20this%20only%20happens%20when%20I%20load%20it%20to%20an%20existing%20worksheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%20why%20this%20is%20happening%3F%20%26nbsp%3BI%20am%20loading%20the%20output%20to%20an%20existing%20blank%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-695872%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-698553%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20Loads%20Table%20With%20Additional%20Blank%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-698553%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F236591%22%20target%3D%22_blank%22%3E%40George%20Bonanza%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20I%20understand%20correctly%20what%20in%20Power%20Query%20Editor%20you%20see%20only%205%20columns%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-772259%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20Loads%20Table%20With%20Additional%20Blank%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-772259%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20is%20correct.%20%26nbsp%3BThe%20query%20I%20build%20has%20only%205%20columns.%3C%2FP%3E%3C%2FLINGO-BODY%3E
George Bonanza
Occasional Contributor

Every time I initially load Power Query output to a worksheet the table is always loaded with an additional column that is not in my data.

 

For example, if the query I build has a table with 5 columns when I click Close and Load for the first time the output has 6 columns where the added column is blank and labeled "Column 1".

 

I believe this only happens when I load it to an existing worksheet.

 

Any idea why this is happening?  I am loading the output to an existing blank sheet.

 

Thanks in advance.

 

3 Replies

@George Bonanza 

 

Do I understand correctly what in Power Query Editor you see only 5 columns? 

@Sergei Baklan 

 

That is correct.  The query I build has only 5 columns.

@George Bonanza 

Could you attach small sample file?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies