Unable to get the incremental refresh work

Hi VModani 

Have you solved this question? If you have solved the question, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

Besides, let me add some info

(1) Sources that support folding

Most data sources that have the concept of a query language support query folding. These data sources can include relational databases, OData feeds (including SharePoint lists), Exchange, and Active Directory. However, data sources like flat files, blobs, and web typically do not.

(2) If the View Native Query option isn't enabled (greyed out)

Query folding - Power Query | Microsoft Docs

(3) 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.

Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs

(4) Also, you could check the steps to set up incremental refresh again,

Configure incremental refresh and real-time data for Power BI datasets - Power BI | Microsoft Docs

Best Regards,

Community Support Team _Tang

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