How to achive clickhouse connection with direct query

[Mohith_ei]

I'm seeking advice on how to connect PowerBI to a data warehouse and utilize direct query mode. I've scoured the internet but haven't found any solutions. Can anyone provide guidance on this?

[Anonymous · Accepted solution]

Hi @Mohith_ei ,

After my research, so far Warehouse only supports Import mode.

You can find the limitation here:
Power Query Warehouse (Beta) connector - Power Query | Microsoft Learn
Connect to the Data Warehouse with Power BI - Microsoft Intune | Microsoft Learn

And if you have a large amount of data, I would recommend a workaround with either using Pipeline Deployment in the Advanced Workspace or using Power BI Custom Connectors:
How to achive clickhouse connection with direct qu... - Microsoft Fabric Community
GitHub - belyaevvo/ClickHouseConnector: Power BI connector for ClickHouse

In addition, the connection to the data warehouse is still in the testing phase, I suggest that you can make your suggestions here, and maybe one day your suggestions will be accepted and you will be able to use the Direct Query mode to connect to the data warehouse!
idea

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.