Hey Jason McCann,
Is it safe to say that the lworkbook works correctly in Tableau Desktop? Is there any link to something internal to your environment, or is it to an external website (like Google)? Are there any URL parameters being added to the link? I'm am trying to think of anything that the server OS (often the security settings) may be blocking that Tableau can't understand, and is therefore throwing a 500 error. Also, what browser versions are on the machine?
Can you share what the URL is and the items asked about above? That may help to find an answer.
The problem with 500 errors is that they are just "Unknown server error" messages and can be coming from many different places.
Opening port 8060 might help as well.
Hope that helps!
Lénaïc RIÉDINGER, Global Community Engineer Tableau
If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!
I agree that it's probably a firewall/proxy issue. If you have done the due diligence on your end and still can't get through then the case needs to be escalated to the firewall team to have them do a more thorough job of trouble-shooting.
Does the Desktop report work if you run it on the Tableau Server machine? If it does work then maybe it's not a firewall issue. If it doesn't work then it likely IS a firewall problem.
Found this to be an issue with the new AntiVirus that was installed. Whitelisted the directory that server is installed in and I can now publish reports that use Google Sheets as a source.