Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
tomtan
Microsoft Employee
Microsoft Employee

How to achive clickhouse connection with direct query?

Hi Experts,

 

My requirement is that I have a clickhouse with lots of data, and I want to leverage PBI to connect to it to do direct query.

 

I did check lots of the web information on the solution. Finnally what I learned is that we could use clickhouse odbc for the connection. Howerver, due to the quantity of data, it is impossible to full load the table and maybe I need to enable direct query for it.

tomtan_0-1682234240737.png

The challenge is that the default odbc connector doesn't provide direct query option. I also checked the web and it seems that the solution is to develop our own connector leverage Forks · microsoft/DataConnectors · GitHub

 

Question:

1. What is the suggest way for PBI to connect to clickhouse and enable direct query?

2. Is there any shared clickhouse connector for PBI to support direct query?

 

Thanks.

 

3 REPLIES 3
belyaevvo
New Member

You can use power bi custom connector like this https://github.com/belyaevvo/ClickHouseConnector

amitchandak
Super User
Super User

@tomtan , How much is data volume, Are you on the premium version? Make sure you load data in service using the deployment pipeline, you should use a large dataset format in the premium  workspace

 

Power BI Incremental Refresh Pro; Premium Deployment pipeline - https://youtu.be/nIxTRdeCYSE

 

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks. We have data with each day 30M+ rows and we need to cover 1 year's data. So total rows would be 10B. We don't yet use premium version but if it works then we could swich to it. But as I know the load mode may not be able to support such volume data, and thus maybe we need direct query instead.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.