Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
Hello,
Can anyone guide me as to what is the backend process when Incremental Refresh is configured along with 'Detect data changes'.
Would it refresh all the data and see if there is any change in the data? Or it would just look into the field which is configured in 'Detect data changes'?
Please mention any links where it has been explained that how Incremental Refresh works.
Thanks in advance.
Can you guys please help? @Greg_Deckler @parry2k @mwegener @v-lionel-msft
Solved! Go to Solution.
Hello everyone,
The detailed documentation of the working of Incremental Refresh can be referred to here. Understanding this topic will help you understand better about the working of Incremental Refresh when 'Detect data changes' is enabled.
Hello everyone,
The detailed documentation of the working of Incremental Refresh can be referred to here. Understanding this topic will help you understand better about the working of Incremental Refresh when 'Detect data changes' is enabled.
Hi @rajulshah ,
Take the configuration in the document as an example.
If the "Detect data changes" option is not turned on, the data of the last 10 days will be refreshed each time the refresh schedule is executed.
If the "Detect data changes" option is enabled, the refresh range will be further reduced (only rows updated in 10 days.).
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @rajulshah,
this is a difficult topic, where I have not seen many examples yet.
The documentation says the following:
The maximum value of this column is evaluated for each of the periods in the incremental range. If it has not changed since the last refresh, there is no need to refresh the period.
So it it would just look into the field which is configured in 'Detect data changes'.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
User | Count |
---|---|
42 | |
26 | |
23 | |
20 | |
18 |
User | Count |
---|---|
54 | |
43 | |
24 | |
21 | |
20 |