Just wondering if anyone here has Power Query in Excel 2016 working with MySQL?
I'm referring to using the MySQL Connector/Net 6.9.8. (different solution from the other option of using 'MySQL for Excel')
It simply won't show MySQL as a data source in the 'Data' > 'New Query' > 'From Database'.
Similar to these instructions for the earlier version of Excel.
https://support.office.com/en-us/ar...09d-b312-6ea8f84a269b?ui=en-US&rs=en-US&ad=US
Just thought MySQL is such a popular DB that someone here may or may not have it working in Excel 2016 as I've been wrestling with this problem for hours and getting nowhere.
I'm referring to using the MySQL Connector/Net 6.9.8. (different solution from the other option of using 'MySQL for Excel')
It simply won't show MySQL as a data source in the 'Data' > 'New Query' > 'From Database'.
Similar to these instructions for the earlier version of Excel.
https://support.office.com/en-us/ar...09d-b312-6ea8f84a269b?ui=en-US&rs=en-US&ad=US
Just thought MySQL is such a popular DB that someone here may or may not have it working in Excel 2016 as I've been wrestling with this problem for hours and getting nowhere.