Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Duplicate column when I take data from the source

Hello;
when I upload date from the source (database) I got a copyed columns from some of the columns(ex: I got sales column and sales - copy column ), I tried to solve it but unfortunitlly I didn't.

I would be grateful for any suggestions or solutions.

Need Help
Show and Tell
  • themistoklis's avatar
    themistoklis
    3 years ago

    Anonymous 

     

    The source contains the same column and PowerBI gives another alias, which is the correct way to do it.

    Either add an alias to the source field or just rename it on PowerBI (through Power Query)

     

4 Replies

  • Mahesh0016's avatar
    Mahesh0016
    Super User
    3 years ago

    Anonymous 

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hello Mahesh;
      I got like this column and it is not the only one, so it is like this appear in my Bi report and data veiw.

      • themistoklis's avatar
        themistoklis
        Community Champion
        3 years ago

        Anonymous 

         

        The source contains the same column and PowerBI gives another alias, which is the correct way to do it.

        Either add an alias to the source field or just rename it on PowerBI (through Power Query)