No answers. I am having the same issue with tableau desktop version 8 and have not found a solution or a workaround. One post said to use use database views, but unfortunately I do not have access to do so. So I am stuck with waiting for a lifetime and am tired to see the text loading metadata for the past hour!!!
I think I am seeing the same issue as you both - see thread ODBC Connection - SELECT TOP 1
It was suggested to set 'CAP_ODBC_METADATA_SUPPRESS_EXECUTED_QUERY' to 'yes' but that was already set in my TDC file.
Did you ever get to solving your issue or are you still waiting for the 'loading metadata...' text to disappear?
It seems that nobody is going to solve this issue in Tableau. Use Views or Create Stored procedures is not an option for someone without permissions to do it. Please, Could you fix or bring any feedback about what is the status ? . It is not reasonable that a tool like this which is not cheap pretend to solve all the issues with workarounds .