Forum Discussion
Helper VDate Parameters for Incremental Refresh not working
Helper VI validated everything, and am now getting the message in the first screenshot below.
My understanding is that this may be due to the fact that this query is using custom SQL to extract the data from SQL Server. See screenshot. Can I do incremental refresh/query folding if I use custom SQL to extract the data?:
Hi ldwf ,
The answer is possible, but it needs to be verified further. This message appears because PBI was unable to confirm whether the use of query folding is supported.
Incremental refresh for semantic models in Power BI - Supported data sources
Given that your data source is SQL Server, you can publish pbix to Service and use SQL Profiler to trace queries sent to the data source, and if the query in the sent data source has already begun filtering the data, the query folding has begun.
You can also concatenate RangeStart and RangeEnd in the WHERE clause of your SQL statement. This video shows an example:
Natives Queries or ODBC with Incremental Refresh in Power BI - YouTube
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum