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

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?

Resources