- last edited on
i'm new with Excel 2016 database connection while i came from Excel 2010..
I would to use MySql database connection like it describes here:
so i have downloaded and install the MySQL connector/Net 6.10.4 like it requests but in my Excel 2016, following menu data > get data > from Database, i still don't see "From MySQL Database" menu.
Does anybody know why i don't see "From MySQL Database" menu added to "from Database" list? I can only see "from databe Sql Server"; "from database Microsoft Access" and so go on but not the "From MySQL Database"..
12-04-2017 07:50 AM
I've got the same issue: I've followed the instructions in here but can't see the MySQL Connection in the New Query - from DB Dropdown
I'm working with MS Excel 2016 standard edition 32bit on Windows 7 Pro 64bit.
Any idea's or solutions to this by now?
12-04-2017 08:15 AMSolution
Power Query Premium: All Power Query features available for: Professional Plus, Office 365 ProPlus or Excel Standalone
Power Query Public: Available for all other Office Desktop SKUs. Includes all Power Query features, except the following ones: Corporate Power BI Data Catalog, Azure-based data sources, Active Directory, HDFS, SharePoint Lists, Oracle, DB2, MySQL, PostgreSQL, Sybase, Teradata, Exchange, Dynamics CRM, SAP BusinessObjects, Salesforce
01-08-2018 12:52 PM
Sorry. I have the same issue and I read the responses. But couldn't quite understand the solution. Could you please explain how I can solve this issue?
01-08-2018 11:01 PM
01-09-2018 12:10 AM
Thank you very much Andy. I dont have those. So alternatively downloaded an ODBC Installer and connected to MySQL through that.