Microsoft Power BI provides a MySQL import driver. Use version 8.0.23. We are unsure it will work with any other version.
Windows: https://downloads.mysql.com/archives/get/p/10/file/mysql-connector-odbc-8.0.23-winx64.msi
Mac: https://downloads.mysql.com/archives/c-odbc/ (select version 8.0.23)
Unfortunately Microsoft does not provide a MySQL Direct Query driver. CelerData has a PowerBI Direct Query driver for StarRocks only available to enterprise/cloud offerings.
Here is a link on the differences between import and direct query drivers. Import vs Direct Query: Here's What You Need to Know | phData