Forum Discussion

L9's avatar
L9
New Member
7 years ago

Microsoft SQL : The column 'Name' was specified multiple times for '_'.

Hi Community,

 

In my Power Query, I have a strange error after filtering a column on a value.

 

The error message is : "Microsoft SQL : The column 'Name' was specified multiple times for '_'"

 

Despite the error message content, I don't have multiple occurences of column 'Name' in my query.

 

Thanks in advance for your help

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I just got this error when Appending two tables together where the columns had the same name but in different case.  One was all Caps and the other was mixed case:  CUSTOMER and Customer.  The crazy part is that the query looks fine in the editor.  You get the error on refresh.

  • PattemManohar's avatar
    PattemManohar
    Community Champion
    7 years ago

    For detail understanding of the issue, Could you Please post the structure/screenshot of table for which you are getting this error. 

    • L9's avatar
      L9
      New Member
      7 years ago

      Hi pattemmanohar,

       

      Thank you for your quick reply.

       

      I can only screenshot the error for data confidentiality purpose :

       

       

      Hope this help to better understand the trouble.

      • PattemManohar's avatar
        PattemManohar
        Community Champion
        7 years ago

        Based on the screenshot, I guess the query has more than one field with "Name" as columnname...  Please check and have unique alias names....

    • JamalGilani's avatar
      JamalGilani
      Frequent Visitor
      2 years ago

      It happens sometime when you have bring data from multiple tables in Table grid.

      But when you remove the relationship field it goes away.