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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
psyche2k
Frequent Visitor

Incremental refresh not retaining previous data

I have two queries. One is getting refreshed daily and giving the current date's data. And the other one is historical static data.
I want the data from the daily refreshing query to append to the historical data. 

Currently what's happening is it overwrites the daily data in the most recent input  of historical data. we have the data of 21st april after 18th april where as we need 19th, 20th, 21 and so on. What it is doing is it is overwriting the previous data with new one.we have the data of 21st april after 18th april where as we need 19th, 20th, 21 and so on. What it is doing is it is overwriting the previous data with new one.

2 REPLIES 2
v-yiruan-msft
Community Support
Community Support

Hi @psyche2k ,

If I understand correctly, it seems that some data from Apr 19th to Apr 21st are missing in your visual after refreshed. Could you please check and confirm if the data for these dates exist in the table exactly? Is there any other filter or slicer may filter out these data? How did you set your matrix visual? The data of matrix visual only include both currect date data and historical data?

Best Regards

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

So the data of 19th April only get refreshed on 19th then 20 will only show up on 20th april and it is showing current date in the last column. It overwrites the data that gets refreshed daily. I need to retain that data!!
Please 4let me know if the question is clear or do you need more specifics.

 

Now if I give a screenshot of report today it will give us data till 18th April and then only of 27th April. No data in between

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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