Home

Excel Bug: tables with Power Query and without header row

%3CLINGO-SUB%20id%3D%22lingo-sub-754658%22%20slang%3D%22en-US%22%3EExcel%20Bug%3A%20tables%20with%20Power%20Query%20and%20without%20header%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754658%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Microsoft%20Tech%20Community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20report%20an%20Excel%20bug%20as%20follows%20(Windows%2010%2C%20Excel%20build%2011601.20204%20click-and-go%2C%20Version%201904%20-%20Office%20365%20monthly%20channel)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20bug%20occurs%20when%20all%20three%20of%20the%20following%20conditions%20apply%3A%3C%2FP%3E%3CP%3E%26nbsp%3B-%20displaying%20data%20from%20a%20Power%20Query%20query%20in%20an%20Excel%20table%20(i.e.%20VBA%20ListObject%20with%20the%20Power%20Query%20query%20as%20its%20data%20source)%3C%2FP%3E%3CP%3E%26nbsp%3B-%20the%20Excel%20table%20has%20been%20set%20to%20have%20no%20header%20row%3C%2FP%3E%3CP%3E%26nbsp%3B-%20the%20Power%20Query%20query%20previously%20had%20a%20result%20with%20%26gt%3B%3D1%20rows%3C%2FP%3E%3CP%3E%26nbsp%3B-%20the%20new%20result%20of%20the%20Power%20Query%20query%20has%200%20rows%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20observed%20behaviour%20is%20that%20what%20had%20been%20the%20last%20result%20row%20of%20the%20Power%20Query%20query%20is%20copied%20to%20where%20the%20header%20row%20of%20the%20result%20table%20would%20be%20if%20there%20were%20a%20header%20row.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20cannot%20imagine%20that%20this%20is%20intended%20behaviour%20(overwriting%20the%20contents%20of%20the%20cells%20in%20the%20theoretical%20location%20of%20the%20header%20row%3B%20putting%20table%20data%20in%20a%20place%20where%20structural%20information%20(column%20headings)%20should%20be).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attach%20a%20demo%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20please%20fix.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20and%20best%20regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJames%20Denman%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-754658%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
James_Denman_Wall_GmbH
New Contributor

Dear Microsoft Tech Community,

 

I would like to report an Excel bug as follows (Windows 10, Excel build 11601.20204 click-and-go, Version 1904 - Office 365 monthly channel):

 

The bug occurs when all three of the following conditions apply:

 - displaying data from a Power Query query in an Excel table (i.e. VBA ListObject with the Power Query query as its data source)

 - the Excel table has been set to have no header row

 - the Power Query query previously had a result with >=1 rows

 - the new result of the Power Query query has 0 rows

 

The observed behaviour is that what had been the last result row of the Power Query query is copied to where the header row of the result table would be if there were a header row.

 

I cannot imagine that this is intended behaviour (overwriting the contents of the cells in the theoretical location of the header row; putting table data in a place where structural information (column headings) should be).

 

I attach a demo file.

 

Could you please fix.

 

Thanks and best regards,

 

James Denman

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies