Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Post Patron
Post Patron

Need help for the clarification of Incremental refresh .

I have some questions according to the Incremental refresh. Please give me their answers with an example.

Question 1. Why date should be static(Order date, transaction date) in which we applied Incremental refresh ranges (start and end ranges ) ??.

Question 2.Why we don't use the same date for data detect changes and incremental refresh ranges .??


And if Qusestion 1 answer is yes. Then let me know how to apply incremental refresh on the dimensions table. because in the dimension table I don't have any static date like order date or transaction date.


Community Support
Community Support

Hi, @adeeln ;

According to your description, when setting incremental refresh, the parameter value can only be set to a static date. If you want to make the data dynamic, you may be able to change the parameter date after publishing to the service.


Or use REST APT to update parameter .
In addition, incremental refresh can only be used if there is a date, if your table does not have a date column, you can consider full refresh.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


@v-yalanwu-msft Thanks for your reply.
1 . Can you please explain why it is necessary to apply Incremental refresh on a static date?. What will be their Drawbacks if we are not using static date for Incremental refresh >
2 . And what about Data Detect changes I have applied Incremental Refresh on the report like the below-attached image. Does Incremental refresh works on it or not?? 



Thanks and Regards.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors