Forum Discussion

Copper Contributor

Jun 17, 2019

Power Query Loads Table With Additional Blank Column

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

Diamond Contributor

Jun 17, 2019

George Bonanza

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

George Bonanza

Copper Contributor

Jul 24, 2019

SergeiBaklan

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

SergeiBaklan
Diamond Contributor
Jul 24, 2019
George Bonanza

Could you attach small sample file?
- mdbrierley
  Copper Contributor
  Apr 08, 2021
  Hi,
  I'm getting the same issue. Was there a solution to this please chaps?
  Thanks
  - SergeiBaklan
    Diamond Contributor
    Apr 08, 2021
    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.