Forum Discussion
Incremental refresh with Import Mode
Dear All, We have couple of reports which are based on SQL queries using the 'Import' Data Connectivity Mode. I have configured incremental refresh but I dont know if Incremental refreshes works...
Thank you for the reply.
My query is simple and there are no steps implemented in Power Query. Still the Native Query option is disabled.
have you ever came accross such senario?
Regards
yes, another reason why the native query is greyed out, is if you supplied a SQL query in your connection. Are you using a select statement for your query?
Yes it is a select statment with some SQL level filters.
So, which this setup is query folding possible? And if query folding is not possible(View Native Query grayed out) will incremental refresh work?
Try hard coding the function to enable the query folding, as shown in this video: https://www.youtube.com/watch?v=8hjdOCni_ZY
Even though it is greyed out, it should work, but please also validate it.