Forum Discussion

sun-sboyanapall's avatar
sun-sboyanapall
Icon for Advocate I rankAdvocate I
2 years ago
Solved

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 t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    sun-sboyanapall
    Icon for Advocate I rankAdvocate I
    2 years ago

    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.