Forum Discussion

AnneGupta's avatar
AnneGupta
Frequent Visitor
3 years ago
Solved

Duplicate Columns Automatically Added

New-ish to Power BI so forgive my ignorance. I imported 12 .txt files with a year's worth of data into Power BI. I appended the queries as they were all formatted the same (or so I thought) as I want...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi AnneGupta ,

    This always happen when the column names are not exactly the same. I notice that there is a space before the "Product" column, is this the same in all files? Please also check that there is no space after the column name.

    Here's the same problem with you: Solved: Append Query duplicates some columns - Microsoft Power BI Community

     

    Best regards,

    Community Support Team_kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi AnneGupta ,

This always happen when the column names are not exactly the same. I notice that there is a space before the "Product" column, is this the same in all files? Please also check that there is no space after the column name.

Here's the same problem with you: Solved: Append Query duplicates some columns - Microsoft Power BI Community

 

Best regards,

Community Support Team_kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.