Powerbi connects to apache doris

[Meguru]

I use the MySQL Connector/NET 8.0.28 driver, and it works fine in Power Query. However, I encounter an error after clicking Apply. How can I resolve this issue?

I found that downgrading the driver to version 6.9.x allows it to work properly. The challenge is that in my work, I need to connect to both MySQL (version 8.x) and Doris (version 5.7.99) databases simultaneously. Any suggestions on how to address this situation?

[amustafa · Accepted solution]

Well, consider using MariaDB driver as suggested here:

MySQL Connector NET doesn't working - Power Platform Community (microsoft.com)

[Meguru]

I didn't expect that I could also connect using MariaDB, very useful.

Thank you so much for your your response!!