locked
How to combine tables in powerpivot RRS feed

  • Question

  • Hello. I had a CSV file with 800,000 rows. I manipulated it with power query and then a little bit more with power pivot. I downloaded another 800,000 to a new file, and did the same thing. The format and columns are exactly the same in both files. I created a table with power query that I wanted to add into the table that I had for the first file in powerpivot but it won't let me merge the two tables. how can I do this? 
    Tuesday, July 26, 2016 9:53 PM

Answers

  • Hello Alex,

    In PowerPivot you can not merge the two tables, but you can do it easily in PowerQuery.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, July 27, 2016 7:21 AM
  • Hi Alex,

    According to your description, you need to combine the data in two tables into one table in Power Pivot data model, right?

    As Olaf said, there is no such a functionally to achieve this requirement in current version of PowerPivot. If you have any concern about this behavior, you can submit a feedback at http://connect.microsoft.com/SQLServer/Feedback and hope it is resolved in the next release of service pack or product. Your feedback enables Microsoft to make software and services the best that they can be, Microsoft might consider to add this feature in the following release after official confirmation.

    We can achieve this requirement in Power BI easily by using Append Queries.

    Regards,


    Charlie Liao
    TechNet Community Support

    • Proposed as answer by Charlie Liao Saturday, August 6, 2016 8:17 AM
    • Marked as answer by Charlie Liao Monday, August 8, 2016 2:27 AM
    Saturday, July 30, 2016 6:06 AM

All replies

  • Hello Alex,

    In PowerPivot you can not merge the two tables, but you can do it easily in PowerQuery.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, July 27, 2016 7:21 AM
  • Hi Alex,

    According to your description, you need to combine the data in two tables into one table in Power Pivot data model, right?

    As Olaf said, there is no such a functionally to achieve this requirement in current version of PowerPivot. If you have any concern about this behavior, you can submit a feedback at http://connect.microsoft.com/SQLServer/Feedback and hope it is resolved in the next release of service pack or product. Your feedback enables Microsoft to make software and services the best that they can be, Microsoft might consider to add this feature in the following release after official confirmation.

    We can achieve this requirement in Power BI easily by using Append Queries.

    Regards,


    Charlie Liao
    TechNet Community Support

    • Proposed as answer by Charlie Liao Saturday, August 6, 2016 8:17 AM
    • Marked as answer by Charlie Liao Monday, August 8, 2016 2:27 AM
    Saturday, July 30, 2016 6:06 AM