DirectQuery with ClickHouse in Power BI Report Server?
Hi everyone, I’m trying to use DirectQuery with a ClickHouse data source in Power BI Report Server. In Power BI Desktop the ClickHouse connector lets me work in DirectQuery mode without any issues. However, the same connector is not available in Power BI Report Server. The ClickHouse documentation (see https://clickhouse.com/docs/integrations/powerbi) suggests using an ODBC connection for the server version, but the ODBC driver only supports Import mode. Because I’m dealing with several billions of rows, Import mode is not feasible for me. Can anyone confirm whether DirectQuery with ClickHouse is possible in Power BI Report Server? If it is supported, could you point me to the required steps or a suitable driver? Otherwise, are there any work‑arounds to achieve near‑real‑time querying on such large datasets? Thank you for your help!
