cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Snapshot Data

Hi,

 

I have a dataset that has dynamic data from a daily refresh:

 

IDStatusCreate DateEnd Date
1Open5/1/2020 
2Closed 5/5/20205/20/2020
3Pending 5/3/2020 

 

This data refreshes every day so each row will ultimately change its 'Status' and 'End Date'.

 

Is there a way to save a snapshot of the data so that every time it refreshes I can see the new status for the distinct ID? 

 

For example

 

IDStatusCreate DateEnd DateLoad Date
1Open5/1/2020 5/20/2020
1Closed 5/1/20205/21/20205/21/2020
2Closed 5/5/20205/20/20205/20/2020
2Closed 5/5/20205/20/20205/21/2020
3Pending 5/3/2020 5/20/2020
3Closed 5/3/20205/21/20205/21/2020
2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Snapshot Data

Hi @kbig02 ,

 

I saw a similar post I recently. It's about in which scenario Power BI will save or drop old data when using Incremental refresh.

https://community.powerbi.com/t5/Service/Incremental-refresh-changes-in-old-data/m-p/971408

Hopefully works for you.

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.
Highlighted
Community Support
Community Support

Re: Snapshot Data

Hi @kbig02 ,

 

Did your problem be solved? If the last reply helped you, please consider accept it as a solution.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors