PowerPivot

• Question

• 

  

  0

  Sign in to vote

  Hello, 

  I am working with PowerPivot and need help with the following problem:

  Currently, I am working with a dataset that is 500,000 lines. Each week, additional data comes through for me to update my data model. At 500,000 lines, Excel starts to struggle a little and I imagine will get worse as time progresses.

  As PowerPivot doesn't recognise new lines in an existing dataset, I was hoping someone could help understand a way to update the external data source and either only include the new lines that have been exported or use an alternative platform that can house larger datasets.

  Any help would be greatly appreciated.

  Kind Regards,

  Adrian 

  Sunday, October 2, 2016 10:14 PM