How to connect Power BI to StarRocks

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)