Forum Discussion

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

Power M Query - Table.SelectColumns tries to convert all to number

Hi - I'm trying to use Power Query to pull in selected columns from a table and it seems like every column I reference, accept the frust one is attemped to be convereted to number. IF I query one column its fine, once I add another I get the error message.  Can someone please tell me what I am doing wrong? Thank you 

 

 

 

 

Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    The list of columns you want to select needs to be within {}, e.g.

    = Table.SelectColumns(MSS_Flat_Fee_Hours, { "Start date", "End date" } )

2 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    4 years ago

    The list of columns you want to select needs to be within {}, e.g.

    = Table.SelectColumns(MSS_Flat_Fee_Hours, { "Start date", "End date" } )