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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
huss2
Frequent Visitor

Cannot load model Clcikhouse

Hi , 

I created power bi datashboard using "Clickhouse Connector" in direct query mode that use Clickhouse as database.after publish dashboard to power bi clcoud 
I recive this error when open dashboard on cloud 

any suggestion ???

 

huss2_1-1695542867929.png

 

 

1 ACCEPTED SOLUTION
v-rongtiep-msft
Community Support
Community Support

Hi @huss2 ,

This error may be caused by one of the following reasons:

  • The Clickhouse Connector is not compatible with the Power BI service, as it is a third-party product that is still in beta version.
  • The Power BI service does not support some of the functions or syntax that you used in your query, such as arrayJoin, arrayElement, etc. You may need to modify your query to use only supported functions or syntax.
  • The Power BI service does not have the correct credentials or permissions to access the Clickhouse data source. You may need to check your data source settings and make sure you have entered the correct server, port, database, username, password, and options.

Best Regards
Community Support Team _ Rongtie

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

View solution in original post

4 REPLIES 4
v-rongtiep-msft
Community Support
Community Support

Hi @huss2 ,

This error may be caused by one of the following reasons:

  • The Clickhouse Connector is not compatible with the Power BI service, as it is a third-party product that is still in beta version.
  • The Power BI service does not support some of the functions or syntax that you used in your query, such as arrayJoin, arrayElement, etc. You may need to modify your query to use only supported functions or syntax.
  • The Power BI service does not have the correct credentials or permissions to access the Clickhouse data source. You may need to check your data source settings and make sure you have entered the correct server, port, database, username, password, and options.

Best Regards
Community Support Team _ Rongtie

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

Hi,

Thank you for your reply. As you mentioned, Power BI Cloud could not connect to our ClickHouse server. However, when I tried to use my personal gateway to establish a connection, I encountered an issue. Unlike the import method, where my personal gateway works fine, I can't even switch it on to add the gateway.

Do you have any suggestions, please?

huss2_0-1696058882637.png

 

Oh, so you did not share that Import Mode works ok and that Direct Query failed.  Always be wary of what appears to be an augmented response.  Please share if this was working, what you have tried, and where you are stuck.  How is the communication with Clickhouse coming? 

foodd
Super User
Super User

Hello @huss2, and thank you for starting a conversation in the Desktop Forum.

 

As Clickhouse is a third-party product, it is recommended that you reach out to 

Clickhouse for support on this issue.  You may try the Slack Channel, or raise 

a Support Request as you see fit.

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.