Installed "MySQL connector/Net 6.10.4" but don't see Excel 2016 menu selection "from MySQL Database"

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:

https://support.office.com/it-it/article/Connettersi-a-un-database-MySQL-Power-Query-8760c647-88b9-409d-b312-6ea8f84a269b?ui=it-IT&rs=it-IT&ad=IT#ID0EAAEAAA=2016

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"..

BI & Data Analytics

training

Andy Frei
Dec 04, 2017
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

6 Replies

Andy Frei
Copper Contributor
Dec 04, 2017
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
- amir.sadighian
  Copper Contributor
  Jan 08, 2018
  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?
  - Andy Frei
    Copper Contributor
    Jan 09, 2018
    What Office version do you have?
    
    It only works if you have Professional Plus, Office 365 ProPlus or Excel Standalone.
Andy Frei
Copper Contributor
Dec 04, 2017
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?

Forum Discussion

Installed "MySQL connector/Net 6.10.4" but don't see Excel 2016 menu selection "from MySQL Database"

6 Replies

Resources