Incremental refresh is not working as expected

Hi Mahipal​,

Doesn't seem any issue with your incremental refresh setup.

Please check below points:-

1. Confirm the column data type (Should be date time)
2. Check the position of the filter step, should be immediatly after the Snowflake table is selected and befor any tranformations, e.g. 

   let     Source = Snowflake.Databases(...),     Database = Source{[Name="YourDatabase"]}[Data],     Schema = Database{[Name="YourSchema"]}[Data],     CASES_Table = Schema{[Name="CASES"]}[Data],      FilteredCases =         Table.SelectRows(             CASES_Table,             each [LASTMODIFIEDDATE] >= RangeStart                 and [LASTMODIFIEDDATE] < RangeEnd         ) in     FilteredCases

3. Test query folding - Check for View native query and make sure that the SQL contains the date filter and is being passed to snowflake correctly

   WHERE LASTMODIFIEDDATE >= ...   AND LASTMODIFIEDDATE < ...

4. Check Snowflake query history - In Snowflake, inspect the SQL generated during the Power BI refresh. it should contain:-

   WHERE LASTMODIFIEDDATE >= '2026-09-07'   AND LASTMODIFIEDDATE < '2026-09-12'

5. Check whether the first service refresh completed successfully - The first refresh after publishing creates the historical and incremental partitions. If the initial refresh failed, was cancelled, or the model was republished afterward, the expected partition structure may not exist. Refer documentation
6. Microsoft recommends that the change-detection column generally be different from the column used to partition the data.
7. Check date format in Power BI and snowflake

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUserand Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

Hi Mahipal​,

One thing I would add is that the second refresh taking roughly the same amount of time does not necessarily mean incremental refresh is not working.

With your current policy, Power BI will refresh the entire last 5 days on every service refresh. Microsoft's incremental refresh documentation states that all rows within the configured refresh period are refreshed each time.

In your screenshot, Detect data changes is not enabled, so Power BI is not trying to determine whether individual daily partitions actually changed before refreshing them.

The first refresh is different because it creates and loads the historical partitions as well as the recent refresh partitions. After that, only the configured refresh window should normally be processed.

So I would verify what Snowflake is actually receiving before concluding that incremental refresh is failing. In Snowflake Query History, compare the SQL generated by the first and second Power BI Service refreshes and check whether the later refresh contains LASTMODIFIEDDATE predicates covering only the recent 5-day window.

If the second refresh is querying only those recent dates, then incremental refresh is working even if the total duration happens to be similar.

If you have another reliable audit/change timestamp, you could also consider Detect data changes. Microsoft documents that this can skip periods whose maximum change value has not changed since the previous refresh. I would not use the same column that you are already using for RangeStart / RangeEnd partitioning.

So I would check:

1. whether the RangeStart / RangeEnd filter folds to Snowflake;
2. what date predicates appear in Snowflake Query History on the second refresh;
3. how much of your total data volume actually falls inside those five days.

That should tell you whether the issue is the incremental-refresh policy or simply that the five-day refresh window itself is still expensive.

AI-assisted drafting: AI was used to help structure and phrase this response. I reviewed and validated the technical content before posting.