This solution would work, but its not realistic for my case. Most reporting environments just call the proc. This blog is talking about linked servers and Open query which is a no-no in my company for security reasons. Security is a blessing and a curse :). So the short answer to this question is that Tableau can support procs, but the solution is unrealistic in companies that are locked down with tight security.
Thanks again for your time.
http://onlinehelp.tableau.com/current/pro/desktop/en-us/connect_basic_stored_procedures.html
Are you running an older version that is still limited? Just curious, I don't know the product.