Connect clickhouse hosted on AWS with powerBI

[Anonymous]

Hi,

I am getting error when trying to connect clickhouse which is hosted on AWS with PowerBI services.

Can anyone help with this issue, Thanks in advance.

[v-yueyunzh-msft]

Hi , @Anonymous 

According to your description, you are getting error when trying to connect clickhouse which is hosted on AWS.

First of all, the data source you connect to is located on your AWS ECS, first you need to make sure that the address of your data source is accessible in the public network?

If your data source can only be accessed in your AWS intranet, you need to download the on-premises data gateway on your AWS VM and configure it.

For more information, you can refer to :

Power BI Gateway | Microsoft Power BI

On-premises data gateway - Power BI | Microsoft Learn

If your AWS can be accessed on the public network but still reports a connection error, you can try checking whether your virtual machine will block  a connection request for the Power BI service.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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