Forum Discussion
Clickhouse connector - How to query
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.
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 FilteredRowsRegards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
3 Replies
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 FilteredRowsRegards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
This solution is still goihg to bring in all the data and then query on top of it right?