Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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.
You can use power bi custom connector like this https://github.com/belyaevvo/ClickHouseConnector
@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
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
63 | |
62 | |
52 | |
39 | |
24 |
User | Count |
---|---|
84 | |
57 | |
45 | |
44 | |
36 |