Forum Discussion
Powerbi connects to apache doris
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?
Well, consider using MariaDB driver as suggested here:
MySQL Connector NET doesn't working - Power Platform Community (microsoft.com)
2 Replies
- amustafa
Solution Sage
Well, consider using MariaDB driver as suggested here:
MySQL Connector NET doesn't working - Power Platform Community (microsoft.com)
I didn't expect that I could also connect using MariaDB, very useful.
Thank you so much for your your response!!
