1 Reply Latest reply on Dec 31, 2018 3:40 PM by patrick.byrne.0

    Error connecting to google sheet

    Information Management

      Hi,

       

      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.

       

      Any ideas how to solve this?

       

      Capture.JPG

       

      Thanks!

      Ronny

        • 1. Re: Error connecting to google sheet
          patrick.byrne.0

          Hello Ronny,

           

          Are you still experiencing this error? I quite frequently connect Tableau Desktop to Google Sheets and have not seen this error before. I would try to re-establish the connection to Google Sheets and attempt to connect to the Google Sheet.

           

          Another troubleshooting step would be to recreate the Google Sheet and connect to the newly created sheet.

           

          Hope this helps!

           

          Cheers,

          Byrne, Patrick

          Community Manager

          Tableau Software