Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

MariaDB Connection with Power BI app

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!

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

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

     

     

    • RennanZanon's avatar
      RennanZanon
      New Member
      5 years ago

      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's avatar
        lbendlin
        Super User
        5 years ago

        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.

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    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.