Forum Discussion

pat8jan's avatar
pat8jan
Regular Visitor
6 years ago
Solved

Native SQL on MySQL database in Dataflow

Hi,   I have a problem using Native SQL when connecting to MySQL database in Dataflow. When i tried to create Dataflow i chose Blank Query and used this statement: let Source = MySql.Databas...
Dataflow
  • pat8jan's avatar
    pat8jan
    6 years ago

    There's no problem with gateway accessing the database or any connection problem. I can use MySQL source in Dataflow and import tables. I just cannot use native sql to import data based on written query.

    Update:
    It started working on it's own without any changes on my side.

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago
Hi pat8jan ,
 
Before you can connect to a MySQL database, you need to install MySQL Connector/Net 6.6.5 for Microsoft Windows on your computer. Select the driver that matches your Power BI Desktop installation (32-bit or 64-bit).
 
After installing the MySQL connector, refer to this blog to connect to MySQL in Power BI Desktop.
 
If the connection still fails in Power BI Desktop, please check that if you are able to connect to the MySQL database in MySQL workbench, ensure that MySQL workbench is installed in the same machine as Power BI Desktop.
 
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
pat8jan's avatar
pat8jan
Regular Visitor
6 years ago
Unfortunately my problem is not within Power BI desktop but Dataflow in Power BI Service.
  • ibarrau's avatar
    ibarrau
    Super User
    6 years ago

    Hi. You have to try Lian solution on the server. Install the MySQL driver on the VM that contains the Gateway. That is how DataFlow will discover the datasource.

     

    Regards,

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

    • pat8jan's avatar
      pat8jan
      Regular Visitor
      6 years ago

      There's no problem with gateway accessing the database or any connection problem. I can use MySQL source in Dataflow and import tables. I just cannot use native sql to import data based on written query.

      Update:
      It started working on it's own without any changes on my side.