Clickhouse connector - How to query

[sun-sboyanapall]

So I have installed this  connector on my local machine from. 

https://github.com/ClickHouse/power-bi-clickhouse

https://github.com/belyaevvo/ClickHouseConnector

Installed both of them and tried both of them. where I am stuck is there is no option to qrite a qeury, as there is lot of data and with direct connection I would like to utilize paramters to filter the data. 

this is what i got in advanced editor view:
"
let
Source = ClickHouse.Database("0.00.00.00", 8123, "default", null),
default_Database = Source{[Name="default",Kind="Database"]}[Data],
ad_lookup_Table = default_Database{[Name="ad_lookup",Kind="Table"]}[Data]
in
ad_lookup_Table


To this how can I add the Query. so I can filter specific column or ID.

[v-nuoc-msft · Accepted solution]

Hi @sun-sboyanapall 

Please try the following M code:

let     
Source = ClickHouse.Database("0.00.00.00", 8123, "default", null),     
default_Database = Source{[Name="default",Kind="Database"]}[Data],     
ad_lookup_Table = default_Database{[Name="ad_lookup",Kind="Table"]}[Data],     
FilteredRows = Table.SelectRows(ad_lookup_Table, each [YourColumnName] = "YourDesiredValue") 
in     
FilteredRows

Regards,

Nono Chen

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

[sun-sboyanapall]

This solution is still goihg to bring in all the data and then query on top of it right?

[v-nuoc-msft · Accepted solution]

Hi @sun-sboyanapall 

Please try the following M code:

let     
Source = ClickHouse.Database("0.00.00.00", 8123, "default", null),     
default_Database = Source{[Name="default",Kind="Database"]}[Data],     
ad_lookup_Table = default_Database{[Name="ad_lookup",Kind="Table"]}[Data],     
FilteredRows = Table.SelectRows(ad_lookup_Table, each [YourColumnName] = "YourDesiredValue") 
in     
FilteredRows

Regards,

Nono Chen

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

[sun-sboyanapall · Accepted solution]

okay what i found was If I add a filter it is able to add it to the query. and it is not retrieving all the data before executing. Thank You.