It sounds to me like a credential / login issue. I'd be willing to bet it's trying to redirect o the login page or something, but that's failing.
Even though I'm able to access the Tableau Report in Chrome without re-logging in & I don't have this issue in IE? If this is the case, do you know how I can give tableau the proper credential information?
It could be that your session is cached in IE but not in Chrome, something along those lines. I'd try clearing all your cache and cookies in IE and seeing if that allows you to replicate the same.
Unfortunately I don't have a lot of experience in this area, just hoping that I might be able to provide some food for thought while others weigh in.
I had the same issues and fixed it by allowing third-party cookies in Chrome:
Go to "Settings" > "Show advanced settings" > "Content settings..." >
and uncheck "Block third-party cookies and site data"
You need to 4-5 solutions to fix err_too_many redirects error in chrome:
1. clear all data of chrome including caches, cookies and history
2. mak sure that site you are trying to visit is not dead, you can check that info by visiting site not down website
3. make new profile on chrome
4. reset chrome
If you want to apply step by step solution then you can refer solutions on https://wildtricks.com/chrome/err_too_many_redirects-wordpress , atleas one solution will fix err_too_many_redirects error on chrome. You will also get many other solutions and suggestions to fix this error on the above site.