Forum Discussion

AL___'s avatar
AL___
New Member
6 years ago
Solved

Direct Query MySQL

Hello,

 

maybe i can find some help here...

Is it possible to connect our Power BI Desktop to MySQL with an "direct query"? Is there any way to reach this or is there an alternatvie (timetable-refreshing?) to have refreshed datas at Power BI Desktop?

 

We desperately need automatic refreshed datas. If there is no possibility to achieve this with MySQL, maybe we should switch to an SQL database?

 

Thanks in advance and best regards,

AL

Need Help

20 Replies

  • bizzybisnette's avatar
    bizzybisnette
    Frequent Visitor
    5 years ago

    MySql is one of the larger databases out there I cannot believe directquery is not supported. I was shocked to find that out. 

    • gfross's avatar
      gfross
      Helper I
      3 years ago

      In case anyone reads this whole thread, this is the solution. It worked perfect for me. It didn't occur to me to use the MariaDB connector to connect to MySQL. Thank you victorviro!!

    • navinrangar's avatar
      navinrangar
      Helper II
      3 years ago

      to all those, who are disappointed by the fact that powerbi directQuery is not supported with mySQL- "this is not full truth."

       

      mySql and mariadb are developed by same people, and are almost identical. so direct query connector/adapter for mariadb

      also work for the mySQL.

       

      1. just download it from above link.

      2. select 'mariadb' in 'get data' option in powerbi

      3. put your 'mySQL' server and database name.

      4. select directQuery mode.

      5. put in your mySQL credentials, and there you are.

       

      additional: in case you want to publish your report to pbi service-

       

      6. publish your pbi desktop direct query report to service.

      7. install a on-premises data gateway on your machine (pc/server)

      8. configure your data gateway in 'manage gateways and connections' in pbi service.

      9. finally go to the dataset setting of the report you just published to pbi service, and connect your data gateway with your pbi dataset.

      10. now whenever you update your mySQL database, and query your report (means open or interact with your report) over pbi service or desktop, that query will securely directly go into your database via that data gateway, and will fetch the updated data to the report, this way you'll see the updated report.

       

      Thanks victorviro for suggesting this amazing trick.

      • Roger14's avatar
        Roger14
        Frequent Visitor
        2 years ago

        I tried it, for the connection if it lets me do it, but when I make the relationships of the tables in power bi, I get errors, the same when making measurements, for example the following I am counting the amount of ticket, but filtering those that have id = 1, when I put it on a card I get that error

         

         

        When I try to relate tables I get the same error

         

    • hb-webdev's avatar
      hb-webdev
      Advocate II
      2 years ago

      All I'm doing is adding a table, and I get "This step results in a query that is not supported in DirectQuery mode" on the very first "Source" step...

       

  • kapsule's avatar
    kapsule
    New Member
    6 years ago

    Hi,

     

    I'm starting with PowerBI and a Mysql database. From what I could read from your post, I have the same problem. Did you find a solution? I would like to use directquery to use the new update page function.

     

    Thanks,

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    We're using CData's DSN/ODBC solution. It's working fine. Expensive though. Progress has a similar ODBC driver.