SOLVED

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

Copper Contributor

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

 

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

6 Replies

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?

best response confirmed by Riccardo Lavoro (Copper Contributor)
Solution

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

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?

What Office version do you have?

It only works if you have Professional Plus, Office 365 ProPlus or Excel Standalone.

Thank you very much Andy. I dont have those. So alternatively downloaded an ODBC Installer and connected to MySQL through that. 

 

 

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!

1 best response

Accepted Solutions
best response confirmed by Riccardo Lavoro (Copper Contributor)
Solution

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

View solution in original post