Nov 03 2017
02:36 AM
- last edited on
Jul 12 2019
10:55 AM
by
TechCommunityAP
Nov 03 2017
02:36 AM
- last edited on
Jul 12 2019
10:55 AM
by
TechCommunityAP
Hi everybody,
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"..
Dec 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?
Dec 04 2017 08:15 AM
SolutionPower 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
Jan 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?
Jan 08 2018 11:01 PM
Jan 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.
Apr 27 2020 11:34 AM
Hi @Andy Frei
I'm currently facing the same problem - but I just activated my Office 365 Pro Plus licence, ran an update and the MySQL etc. options still don't appear.
What am I doing wrong?
Thanks in advance for your help!
Dec 04 2017 08:15 AM
SolutionPower 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