Forum Discussion
ClickHouse Folding Query
Hey everyone,
I would like to know, if it is possible to query ClickHouse using query folding with the StartDate and EndDate parameters to enable incremental load in Power BI.
How is the setup code?
Thanks,
Thiago.
3 Replies
thiagoqd can you check with query folding indicators: Query folding indicators in Power Query - Power Query | Microsoft Learn
I'm still having a hard time trying to make native query work for incremental reload.
I've started from scratch, and created that script:
The column filtered with the parameters:
The parameters:
The Native Query for folding works till the Navigation step:
But it stops working in the last step (the filter with the parameters:
Does anyone date folding works in Clickhouse?
Thanks.
I'm using the Native Query as an indicator. The Native Query Stops working when I filter the date with the parameters.
