Incremental refresh not working with Impala

[Anonymous]

Hi

I am using Cloudera ODBC connector to connect Impala. I load the table into Query Editor and then remove some columns. At this point, query folding is working and I can see "View native query" option. But as soon as I apply RangeStart and RangeEnd filters to timestamp column, "View native query" option is disabled.

Could you please check if this is a limitation with the given connection type.

Thanks

Gori Shanker Suthar

[Anonymous]

It is working fine now.

"View native query" option is disabled in Power Query, also while setting Incremental load, it gives a warning that query is not folded, but when checked the queries to source, I can see the time filter in where clause.

eg.
... WHERE ((`tableName`.`time_stamp`>=CAST("2021-01-19 00:00:00" AS TIMESTAMP)) AND (`tableName`.`time_stamp`<CAST("2021-01-20 00:00:00" AS TIMESTAMP)))

[v-rzhou-msft]

Hi @Anonymous 

Power Query query folding support Filtering rows, with static values or Power Query parameters (WHERE clause predicates).

Please check your parameter and filter.

Did you add SQL statement in Advanced? This will cause  "View native query" option disabled as well.

For more details about Power Query support and limitation, you may refer to this blog:

Transformations that can achieve folding

Post may help you: View Native Query always disabled

Best Regards,

Rico Zhou

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

[parry2k]

@Anonymous I guess when you are adding that filter, it is not folding back to your data source, and I assume that is the limitation on the ODBC connector.

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡