Can you clarify?
Do you have "_" in sheet names and you get "!" Insted in table names?
What Tableau version are you using?
yes "_" is being chnaged to "!". I am using 9.1.0
I do see it happening with 9.1 but looks fixed in 9.2 (I have 9.2.7).
Does your company have any plans to upgrade?