Forum Discussion

martinkitty's avatar
martinkitty
New Member
6 years ago

Union tables in one query

Hello, I am a quite new user of PowerBI and I wanted to take advantage of PowerQuery to prepare a dataset. I want to append two tables - one is a CSV file that I am importing and second comes from p...
Jimmy801's avatar
Jimmy801
Community Champion
6 years ago

Hello martinkitty 

 

Table.Combine is for sure the right function to use, and I don't know why it should not append tables within your query.

What I can see in your code however, is that you may reference the wrong step. Try to change your last step as follows

Result = Table.Combine({#"Changed Type", refreshed})

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    hi martinkitty 

    if your problem is that indicated from Jimmy801 , then should try, to complete its advice, changing the expression

     

    in this way:

     

     Result = Table.Combine({#"Changed Type", #"Changed Type1"})

     

     

    But if you want to exactly simulate UNION SQL (I just see this sintax for first time)

     

    as explainde here

     

    "The UNION operator selects only distinct values by default."

     

    you should use table.distinc (before and/or after the table.combine)