Forum Discussion

tomtan's avatar
tomtan
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

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 soluti...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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

 

 

tomtan's avatar
tomtan
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

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.