locked
How to append data RRS feed

  • Question

  • Hello. I have a CVS file that I used as a source into a power pivot sheet. Now I have another one that I want to append (1 additional column that should match up to the IDs in the first CVS). How should I handle this? Do a vlookup in the CSV file? Add in as a source and then use related? Anything else? Thanks. 
    Monday, August 15, 2016 5:03 PM

Answers

All replies

  • Hello,

    unfortunately PowerPivot don's support an incremental data load; you can vote for this feature at https://connect.microsoft.com/SQLServer/feedback/details/715765/powerpivot-incremental-data-refresh

    One option is to load your CSV to your Excel sheet as data source for PP; an incremental load can be done using Power Query.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Charlie Liao Wednesday, August 17, 2016 2:28 AM
    • Marked as answer by Charlie Liao Sunday, August 28, 2016 7:26 AM
    Monday, August 15, 2016 5:51 PM
  • You should be able to do this with PowerQuery. You could join the 2 queries together before loading the result into your data model.

    http://darren.gosbell.com - please mark correct answers

    • Proposed as answer by Charlie Liao Wednesday, August 17, 2016 2:28 AM
    • Marked as answer by Charlie Liao Sunday, August 28, 2016 7:26 AM
    Tuesday, August 16, 2016 12:20 PM
  • Hi Alex,

    As their said, you can achieve this requirement in power query. After loaded the data into PowerPivot data model, there is no other functionally to achieve this requirement. By the way you can do this in Power BI desktop easily.

    Regards,


    Charlie Liao
    TechNet Community Support

    Wednesday, August 17, 2016 2:55 AM
  • Well you could do this in PowerPivot as a last resort. You'd have to bring both tables into your model, then you'd hide one and use the lookup function in the other table to pull the value over from the hidden one. But that would waste a lot of RAM keeping 2 copies of the join key in memory for no good reason. It's much better to do this join before you load the data into the PowerPivot model.

    http://darren.gosbell.com - please mark correct answers

    Wednesday, August 17, 2016 7:23 AM
  • Thanks everyone. I figured out how to do it in powerquery. 

    What about if your source is a csv file and you update that file. Then you can refresh correct? 

    Friday, August 19, 2016 10:53 PM
  • What about if your source is a csv file and you update that file. Then you can refresh correct? 

    Yes, when you refresh the PowerQuery code will re-execute, loading the new data and performing the other steps in you PowerQuery query.

    http://darren.gosbell.com - please mark correct answers

    Friday, August 19, 2016 11:06 PM