Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to Solution.
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.
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.
Happy to help!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.