Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Data Change time intelligence - since previous refresh date

Hi,   How does one show the change in data based on the previous refresh date?     I have  list of data on sales pipeline by person that is directly fed from SFDC into my power BI dashboard. I'm...
Need Help
Show and Tell
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi Anonymous,

     

    Currently, the Power Query will override the old data and only show the new data after refreshing. There is no possible way to capture and store historical data in Power BI.

     

    As a workaround, if possible, you could store historical data in your source system where your data comes from. Or find a way to maintain all historical files locally. Each time you refresh data will generate a new file. Then, load data in each period from those files in desktop.

     

    Such a requirement is similar to Incremental refresh, although it is not supported now, it is under review: Incremental Data Loads

     

    Regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi Anonymous,

 

Currently, the Power Query will override the old data and only show the new data after refreshing. There is no possible way to capture and store historical data in Power BI.

 

As a workaround, if possible, you could store historical data in your source system where your data comes from. Or find a way to maintain all historical files locally. Each time you refresh data will generate a new file. Then, load data in each period from those files in desktop.

 

Such a requirement is similar to Incremental refresh, although it is not supported now, it is under review: Incremental Data Loads

 

Regards,
Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi v-yulgu-msft,

     

    Thanks!.. noted. I thought as much. :-)