Someone on Stackoverflow answered this issue which someone else was also having around the same time as me.

Research whether the Connector is registering its' existence correctly to be picked up by Excel.Īpologies, it turns out it's a subtly that MS have introduced in Office 2016. msi install file and is the latest 64 bit version 5.7.10. My install of MySQL is running on the same machine which was installed using the. Using an up to date Windows 10 system and Office 2016 32bit via Office 365, I followed the instructions below substituting the 'Connector/NET' version with the latest 6.9.8. I can't be sure whether the fault lies with the Connector or with Excel. Maybe this is a regression problem with Power Query in Excel 2016 which now has a slightly older version of PQ baked in rather than being a separate add-on as was the case in older Excel versions. It's possible that it should also show in some of the other data menus too, like 'Get External Data' > 'From Other Sources' but doesn't. After installing the 'Connector/Net' add-on I was expecting 'MySQL' to show as a data source in the Excel 'Data' > 'New Query' > 'From Database' menu but it doesn't.

Office 2016 power query