incremental refresh is not happening properly

[Anonymous]

Hello Team,

I have configured the incremental refresh, rangestart: 1st jan 2020 rangeend:31 dec 2021

turned on the incremental refresh for specific table and store rows last 1 year, refresh rows last 1 month. 

when i update some values at table in db then feb month data is updating and showing the values correctly

when i update the modified date for feb its not showing on the reports after dataset refresh successfully.

my power bi file is getting query folding error like below

any idea?

[Anonymous]

Hi @Anonymous ,

According to the official document, If you see this warning and want to verify the necessary query folding is occurring, use the Power Query Diagnostics feature or trace queries by using a tool supported by the data source, like SQL Profiler. If query folding is not occurring, verify the filter logic is included in the query being passed to the data source. If not, it's likely the query includes a transformation that prevents folding.

Note: Only some data sources that have a specific query language support query folding, such as SQL Server, Oracle, and data sources that support ODBC connections. For example, data sources such as Excel, CSV, and Website that do not have any query mechanism do not support query folding. As shown in the figure above, if the imported data is an Excel data source, a yellow warning appears.

You could right-click the last applied step in the APPLIED STEPS tab to determine when a Power Query query can be folded :  If the View Native Query option is enabled (not greyed out), then the entire query can be folded.

For more information, please kindly refer to:

Query folding | Microsoft Docs

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please note that Query Folding is desired for better performance of incremental refresh but it is not a hard requirement. Incremental refresh will still work if the source does not support query folding.

[lbendlin]

Read the fine print. Detect Data changes only works INSIDE the refresh window.  February is outside of your current refresh window.  You can change the refresh window to 12 months and then rely on MOD_DATE to only touch the monthly partitions that actually have changes.