Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Help Needed with Data Flows

Hello community, 

 

Hope every one are safe!!  

 

I have a question and wanted to know if data flows can help us with this requirement . We have huge volumes of data in one of our reporting databases. ( Say from 2016 ) . By every passing year, they delete one year of data and free up the space. For example, we are in year 2020 and we have data from 2016 . In next year 2021,2016 data will be deleted .  For reporting uses, we need data of 2016 as well. 

 

Can data flows help us in archiving this data and doesnt get deleted at all ?

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Community, 

     

    Does any one have a solution for the scenario i explained below. Please help me with this requirement as we need to discuss with client as soon as possible. 

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      6 years ago

      Hi , Anonymous 

      When execute a refresh on next year, the query will execute again and get data from source, the data for year 2016 will loss because there are no such data in source, so we can create another data flow which filter the data in year 2016 and do not refresh it again to store the data for 2016.(if execute refresh again, the stored data will lose and be replaced with new one). you can also use other database to store the entire data, then connect data flow to  it.

       

      Best Regards,
      Community Support Team _ Eason