Power Query Loads Table With Additional Blank Column

Copper 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.

 

5 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?

Hi,
I'm getting the same issue. Was there a solution to this please chaps?
Thanks

@mdbrierley 

If you could provide sample file to reproduce that, or at least give more details about the query, it helps. In my practice I had no such issue.