The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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