Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
v-jayw-msft
Community Support
Community Support

Hi @Anonymous ,

 

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.

Hi @Anonymous ,

 

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors