Forum Discussion

twilbour's avatar
twilbour
Icon for Helper I rankHelper I
5 years ago
Solved

Error: We cannot convert a value of type Table to type List

I have a multi file, multi sheet query.  Once I have all the data combined, I want to duplicate certain rows from the data set, and append back to the list..  I have managed to create the table of du...
Need Help
  • edhans's avatar
    edhans
    5 years ago

    Your Table.Combine syntax is wrong. It requires a list of tables, not just the table names. Change it to:

    #"Append Query" = Table.Combine({#"Filtered Rows2",#"Removed Columns2"})

    Note the {} brackets.

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
5 years ago

Your Table.Combine syntax is wrong. It requires a list of tables, not just the table names. Change it to:

#"Append Query" = Table.Combine({#"Filtered Rows2",#"Removed Columns2"})

Note the {} brackets.

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
5 years ago

twilbour - was this helpful?