New to Tableau here. I'm using Tableau Desktop and am trying to connect to a google sheet and I'm getting the following error:
"An error occurred while communicating with Microsoft Excel Reader.
Bad Connection: Tableau could not connect to the data source.
Errors occurred while loading the data source."
The only info I can find online is about excel files (becoming corrupt, having permission restrictions, having wrong file extensions) but that doesn't seem to resolve my google sheet connection issue. The only thing I can think of is any sheet restrictions or hidden tabs but I've played with that with no success. Important to note here that my other google sheets work fine, so it's only this one.