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 Community,
I am new to using MySQL data source in Power BI Desktop. So far i have used CSV,share point , SQL Server data sources and never faced any issues. However, i am facing below error as shown in screen shot when i am trying to connect to MySQL . I tried clicking on "Learn more" to see if any softwares are required. I tried installing MySQL connector .but it still didnt helped me.
Kindly assist .
G Venkatesh
@Anonymous , Make sure latest mysql .net driver is installed
https://dev.mysql.com/downloads/connector/net/
mysql
https://community.powerbi.com/t5/Power-Query/How-to-connect-to-Azure-MySQL-database/m-p/92467
https://community.powerbi.com/t5/Desktop/How-to-connect-Azure-MySQL-database-in-Power-BI/td-p/703341
https://blog.panoply.io/powerbi-mysql-challenges-and-alternatives
https://technicaljockey.com/microsoft-power-bi-analytics/connecting-powerbi-with-mysql-database/
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-source-prerequisites
@Anonymous - See this thread: https://community.powerbi.com/t5/Power-Query/Trying-to-connect-to-MY-SQL-from-Power-BI/td-p/195060
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.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |