I have read on some articles that Starrocks could be directly connected to Power BI. But when I try to connect using Power BI Desktop, there would be some sort of error that makes it impossible to connect.
If someone could write a step by step guide about connecting and connector between the 2 would be a great help. Thanks!
have you tried the PowerBI mysql connector? If you get an error/issue, we need more info similar to this post. https://forum.mirrorship.cn/t/topic/9740
I have tried the mysql connector with the same errors as your mirrorship topic
Starrocks version: 3.1.0
max_allowed_packet: 1073741824
Power BI version: 2.126.1261.0 (24.02)
Three months gone, have you been able to successfully connect Power BI with Starrocks? I’m in a situation that I need to do the same.
For your question, we stopped making this work. We also didn’t receive any other support further than what you have read.
1 Like
Fred, now three months since you asked. Have you found a solution ? I haven’t yet tried it, but am looking at Starrocks and this was a concern.
And if you have found a solution, was it a MySQL import driver for PowerBI or were you able to make a direct query type of driver work ?
I’m afraid that StarRocks OSS cannot connect with Power BI well. I suggest you contact CelerData in the community Slack. They will have some solutions.