Adding Data into Powerpivot RRS feed

  • Question

  • Hi,

    I recently moved from Access to PowerPivot to consolidate market data (which is released monthly).

    It currently has 2 million rows of data and still going on fine.

    Purpose of this consolidation is to observe market trends but also to enable a refresh of the charts for every new monthly data added.

    I have 2 issues:

    1. I created PowerPivot database in March with all historical data. So April's data is the first time I am adding new data in and it is not possible.

    2. I am concerned on refreshing the data and my charts will not refresh

    Would like to share the file here but seems unable to do so.

    Please help!


    Sunday, April 8, 2018 3:12 AM