Incremental Refresh for Cloudera ODBC connector for Impala

[shrabedi]

How can I configure incremental refresh in Power BI with a Cloudera ODBC connector for Impala, given that the connector does not support query folding and the data I am pulling has billions of rows?

[lbendlin]

Query Folding is not a requirement for Incremental refresh. What is a requirement is to have a suitable DateTime column in your source table, and the ability to run custom queries (which you get with the ODBC connector).  Give it a try.

[shrabedi]

@lbendlin 
I understand that having a suitable DateTime column and the ability to run custom queries are requirements for using this feature. Could you recommend any documentation or online resources that I can refer to in order to set this up?

[lbendlin]

Here's one example https://community.powerbi.com/t5/Community-Blog/Incremental-Refresh-with-Slow-Changing-Source-Data/b...

Try it out and report back when you are stuck.