Forum Discussion

ctedesco3307's avatar
ctedesco3307
Icon for Resolver II rankResolver II
4 years ago
Solved

Merge Query error columns of same type when they are

Hello  - I'm trying to merge 2 tables into one query but I keep getting Select Colunf of the same type error message - however my columns are of the same type.  Any ideas? thank you    ...
Need Help
  • SergioSilvaPT's avatar
    SergioSilvaPT
    4 years ago

    Hi ctedesco3307 

     

    You have to check the data type in Power Query like in the image bellow:

     

     

    Both most be like number "123".

     

    Regards,

    Sérgio Silva 

     
    If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
ctedesco3307's avatar
ctedesco3307
Icon for Resolver II rankResolver II
4 years ago

Thanks - but I can't even get that far. When I select the tables I get the error before the query is made. Both columns are of the same type in the tables. 

SergioSilvaPT's avatar
SergioSilvaPT
Icon for Resolver V rankResolver V
4 years ago

ctedesco3307 can you share the power bi file so i can see what is happening?