Support Native / Custom SQL Queries in Power BI ClickHouse Connector

Currently, the native Power BI ClickHouse connector does not support entering custom SQL or native database queries via Advanced Options, unlike other database connectors (e.g., SQL Server, Oracle).

This limitation prevents users from using complex queries, joins, or business logic directly and forces workarounds such as creating views in ClickHouse or switching to the generic ODBC connector.

We request enhancement of the native ClickHouse connector to support native/custom SQL queries in Power Query, similar to other supported database connectors, while maintaining DirectQuery and query folding where applicable.

power bi

Support Native / Custom SQL Queries in Power BI ClickHouse Connector

Recent ideas

Property type tab at data binding in Ontology

feedback on ontology & Graph - nodes

Add "Collapse all / Expand all" to the Queries pane in Power Query Editor

Add Automated Pre-Upgrade Compatibility Assessment for Fabric Spark Runtimes

Support Creator-Independent Managed Identity and Ownership Transfer for Fabric Operations Agents