I am not sure but earlier I was using Google Sheet with Tableau and I used to see some problem like your whenever I replace the data source with latest data.
Then we moved to Tableau online and now it's working fine. we don't need to replace data any more.
Thanks, Suman. This is all in Tableau Desktop, so no "publish" event gets in the way. It's solely when I refresh the Google Analytics extract in Desktop.