To anyone finding this thread in future, I was having the same issue, and here is my solution.

If the only credentials being used are the ones set up in the ODBC (in the example above the user is "excel") then it is possible you have some cached credentials in the Data Source Settings that need to be removed:

Right Click on any permissions that match your DSN (e.g. dsn=esa ) and clear any unwanted usernames and passwords.

Then, when you try to Get Data from the ODBC data source again, you will get this screen. Click "Default or Custom" and then "Connect" and if configured correctly, you should see the list of tables.

Once you have done this, the "Default or Custom" selection is stored in Data Source Settings so you shouldn't have to do this again.

Hope this helps!