Incremental Refresh from Salesforce-DataLake Gen 2 Connection

Hi common763 ,

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, such as SQL Profiler. If query folding isn't 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.

Before configuring your incremental refresh solution, be sure to thoroughly read and understand Query folding guidance in Power BI Desktop and Power Query query folding. These articles can help you determine whether your data source and queries support query folding.

And I agree with your co-worker.Incremental refresh and real-time data works best for structured, relational data sources like SQL Database and Azure Synapse.

For your requirement, I found this blog for your reference:

Parquet, ADLS Gen2, ETL, and Incremental Refresh i... - Microsoft Fabric Community

Here's the official doc:

Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

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