SOLVED
Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-123831%22%20slang%3D%22en-US%22%3EInstalled%20%22MySQL%20connector%2FNet%206.10.4%22%20but%20don't%20see%20Excel%202016%20menu%20selection%20%22from%20MySQL%20Database%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-123831%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everybody%2C%3C%2FP%3E%3CP%3Ei'm%20new%20with%20Excel%202016%20database%20connection%20while%20i%20came%20from%20Excel%202010..%3C%2FP%3E%3CP%3EI%20would%20to%20use%20MySql%20database%20connection%20like%20it%20describes%20here%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fit-it%2Farticle%2FConnettersi-a-un-database-MySQL-Power-Query-8760c647-88b9-409d-b312-6ea8f84a269b%3Fui%3Dit-IT%26amp%3Brs%3Dit-IT%26amp%3Bad%3DIT%23ID0EAAEAAA%3D2016%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fit-it%2Farticle%2FConnettersi-a-un-database-MySQL-Power-Query-8760c647-88b9-409d-b312-6ea8f84a269b%3Fui%3Dit-IT%26amp%3Brs%3Dit-IT%26amp%3Bad%3DIT%23ID0EAAEAAA%3D2016%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20i%20have%20downloaded%20and%20install%20the%26nbsp%3BMySQL%20connector%2FNet%206.10.4%20like%20it%20requests%20but%20in%20my%20Excel%202016%2C%20following%20menu%26nbsp%3Bdata%20%26gt%3B%26nbsp%3Bget%26nbsp%3Bdata%26nbsp%3B%26gt%3B%26nbsp%3Bfrom%26nbsp%3BDatabase%2C%20i%20still%20don't%20see%20%22From%26nbsp%3BMySQL%20Database%22%20menu.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anybody%20know%20why%20i%20don't%20see%26nbsp%3B%3CSPAN%3E%22From%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3BMySQL%20Database%22%26nbsp%3Bmenu%20added%20to%20%22from%26nbsp%3BDatabase%22%20list%3F%20I%20can%20only%20see%20%22from%20databe%20Sql%20Server%22%3B%20%22from%20database%20Microsoft%20Access%22%20and%20so%20go%20on%20but%20not%20the%26nbsp%3B%22From%26nbsp%3BMySQL%20Database%22..%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-123831%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EGet%20%26amp%3B%20Transform%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-142962%22%20slang%3D%22en-US%22%3ERe%3A%20Installed%20%22MySQL%20connector%2FNet%206.10.4%22%20but%20don't%20see%20Excel%202016%20menu%20selection%20%22f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-142962%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20very%20much%20Andy.%20I%20dont%20have%20those.%20So%20alternatively%20downloaded%20an%20ODBC%20Installer%20and%20connected%20to%20MySQL%20through%20that.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-142952%22%20slang%3D%22en-US%22%3ERe%3A%20Installed%20%22MySQL%20connector%2FNet%206.10.4%22%20but%20don't%20see%20Excel%202016%20menu%20selection%20%22f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-142952%22%20slang%3D%22en-US%22%3EWhat%20Office%20version%20do%20you%20have%3F%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20only%20works%20if%20you%20have%20Professional%20Plus%2C%20Office%20365%20ProPlus%20or%20Excel%20Standalone.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-142783%22%20slang%3D%22en-US%22%3ERe%3A%20Installed%20%22MySQL%20connector%2FNet%206.10.4%22%20but%20don't%20see%20Excel%202016%20menu%20selection%20%22f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-142783%22%20slang%3D%22en-US%22%3E%3CP%3ESorry.%20I%20have%20the%20same%20issue%20and%20I%20read%20the%20responses.%20But%20couldn't%20quite%20understand%20the%20solution.%20Could%20you%20please%20explain%20how%20I%20can%20solve%20this%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-133837%22%20slang%3D%22en-US%22%3ERe%3A%20Installed%20%22MySQL%20connector%2FNet%206.10.4%22%20but%20don't%20see%20Excel%202016%20menu%20selection%20%22f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-133837%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EPower%20Query%20Premium%3A%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3BAll%20Power%20Query%20features%20available%20for%3A%20Professional%20Plus%2C%20Office%20365%20ProPlus%20or%20Excel%20Standalone%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSTRONG%3EPower%20Query%20Public%3A%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3BAvailable%20for%20all%20other%20Office%20Desktop%20SKUs.%20Includes%20all%20Power%20Query%20features%2C%20%3CEM%3Eexcept%20the%20following%20ones%3A%3C%2FEM%3E%20Corporate%20Power%20BI%20Data%20Catalog%2C%20Azure-based%20data%20sources%2C%20Active%20Directory%2C%20HDFS%2C%20SharePoint%20Lists%2C%20Oracle%2C%20DB2%2C%20MySQL%2C%20PostgreSQL%2C%20Sybase%2C%20Teradata%2C%20Exchange%2C%20Dynamics%20CRM%2C%20SAP%20BusinessObjects%2C%20Salesforce%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-133815%22%20slang%3D%22en-US%22%3ERe%3A%20Installed%20%22MySQL%20connector%2FNet%206.10.4%22%20but%20don't%20see%20Excel%202016%20menu%20selection%20%22f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-133815%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20got%20the%20same%20issue%3A%20I've%20followed%20the%20instructions%20in%20here%20but%20can't%20see%20the%20MySQL%20Connection%20in%20the%26nbsp%3B%20New%20Query%20-%20from%20DB%20Dropdown%3C%2FP%3E%0A%3CP%3EI'm%20working%20with%20MS%20Excel%202016%20standard%20edition%2032bit%20on%20Windows%207%20Pro%2064bit.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAny%20idea's%20or%20solutions%20to%20this%20by%20now%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Riccardo Lavoro
Frequent Visitor

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

5 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?

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.