MariaDB Connection with Power BI app

[Anonymous]

Hello all!

I've been trying to use the ODBC connector while creating Dataflows the same way I used to create the connection with ODBC in desktop, but I don't seem to find any connection string to MySQL database or MariaDB database in google...

Does anyone knows if the ODBC connector in the web app supports this type of connection?

Thanks in advance!

[v-lionel-msft]

Hi @Anonymous ,

The current version(September 2020) does not support using ODBC connector to connect to MySQL and MariaDB.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Have you considered the use of the new MariaDB connector (currently in beta)?

[RennanZanon]

Hello! Thank you for your reply!

Yes i've noticed that in Power BI Desktop there's a beta MariaDB connector but I can't find it to define a new entity while creating a dataflow, and the MySQL connector doesn't seems to work properly when trying to connect to my MariaDB Database i guess. 

[lbendlin]

Apologies, didn't read your question well enough. Maybe check the ideas site or raise an idea to have the connector included in the service.