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.
MySQL is my datasource. We so far have been using a single instance and connection is smooth. Now, we want to setup MySQL as a cluster so that we can improve reliability. How can I use MySQL cluster as my data source ?
We were thinking about using this approach
https://dev.mysql.com/doc/x-devapi-userguide/en/connecting-dns-srv.html
to setup multiple nodes.
Any pointers or suggestion for a different approach to have a reliable MySQL and at the same time connect to Power BI seamlessly would be very helpful.
Hi, @ramakrid
I'd like to suggest you use 'Python script' connector to do it. As is said in the document, you may try the Python codes.
Python Code
session = mysqlx.get_session(host="tcp.example.com", dns_srv=True)
For further information, you may refer the following document.
Run Python scripts in Power BI Desktop
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.