locked
PowerPivot RRS feed

  • Question

  • 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 data-set, 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 

    • Moved by litdev Thursday, September 29, 2016 2:18 PM
    • Changed type Adrian555 Thursday, September 29, 2016 10:52 PM Help
    • Changed type Dave PatrickMVP Friday, September 30, 2016 4:25 AM question
    Thursday, September 29, 2016 4:52 AM

Answers

All replies

  • This forum is about the Small Basic programming language. You can better try to find the right forum for your question.

    Jan [ WhTurner ] The Netherlands

    • Proposed as answer by Nonki Takahashi Thursday, September 29, 2016 1:10 PM
    Thursday, September 29, 2016 11:23 AM
  • They'll help you over here.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlkjpowerpivotforexcel

     

     

     



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    • Proposed as answer by pituachMVP Friday, September 30, 2016 9:41 AM
    • Marked as answer by Just Karl Friday, October 7, 2016 10:41 PM
    Friday, September 30, 2016 4:27 AM