I don't know what ODBC driver  I need to enter in the Connection String? I used the ODBC driver I used in MS Query and it said not valid.

Hi,

Do you mind telling us which function did you use? Power query or MS query? They are different.

Power query:

ODBC Connector You can now connect to generic ODBC providers using Power Query, enabling users to import data into Power Query from several data sources that are not natively supported. Connect and import data from ODBC-based data sources by specifying the connection string parameters and a SQL statement to execute.

https://support.office.com/en-us/article/Whats-new-in-Power-Query-936b2fca-4168-41ad-bbbd-7b83856b6776

MS query:

We need to install OBBC driver of Windows, For more detail information, please refer to the following link:

http://answers.microsoft.com/en-us/office/forum/office_2007-excel/no-odbc-drivers-available-for-excel-or-access-in/001c234b-dfd5-4378-a325-c4f1482fb6fd

Hope it's helpful.

George Zhao
TechNet Community Support