Forum Discussion

Riccardo Lavoro's avatar
Riccardo Lavoro
Copper Contributor
Nov 03, 2017
Solved

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/articl...
BI & Data Analytics
training
  • Andy Frei's avatar
    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

Andy Frei's avatar
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's avatar
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's avatar
    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.
    • b3333n's avatar
      b3333n
      Copper Contributor
      Apr 27, 2020

      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!

    • amir.sadighian's avatar
      amir.sadighian
      Copper Contributor
      Jan 09, 2018

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

       

       

Resources