8 Replies Latest reply on Sep 27, 2018 7:46 AM by Suraj Kumar

Error when connecting to Google Sheets (Tableau 10.5.6)

Benny Magnus Jul 27, 2018 2:24 AM

Hi,

I'm trying to connect Tableau with Google Sheets but I always get the below error after I clicked 'Allow' to grant Tableau access to my Google account.

The same issue was solved in the discussion Cannot connect to Google Sheet by using Tableau desktop 10.4 instead of 10.4.1. Does anyone know another solution so I can still continue to work with 10.5.6? Not sure if Tableau is aware of this issue and if they are planning to solve this in a future version?

1. Re: Error when connecting to Google Sheets (Tableau 10.5.6)

kumar bharat Jul 27, 2018 4:05 AM (in response to Benny Magnus)

hi Benny,
How are you establishing a connection to google sheets.
Are you using the native connector to connect to google sheets?
Connecting to Google Sheet and Google Drive Data Source | Tableau Software
https://onlinehelp.tableau.com/current/pro/desktop/en-us/help.htm#examples_googlesheets.html#make_cx
Google Sheets: Deeper spreadsheet data analysis with Tableau
BR,
bharat
Like Show 0 Likes(0)

Actions
2. Re: Error when connecting to Google Sheets (Tableau 10.5.6)

Sebastian Sofariu Jul 27, 2018 3:59 AM (in response to Benny Magnus)

Hi Benny,

I've seen some similar behaviors and the issue was caused by Firewal or the VPN. Most likely is not caused by Tableau.

Since the error states an empty response from ::1, I believe this error is being caused by network settings on the computer which are blocking access to the IPv6 home address. In some systems the IPv6 home, or loopback, address is blocked or disabled. Reasons for this include IPv6 being disabled entirely or security concerns.

There are two options that may handle this situation:

1. If Proxy Server is enabled in Local Area (LAN) Settings of Internet Options:
a. Open up Internet Options
b. Click the LAN settings button on the Connections tab
c. Check the box: Bypass proxy server for local addresses
d. Click the Advanced button
e. Add [::1] to the Exceptions box

2. If "Automatically detect settings or "Use automatic configuration script" is enabled in Local Area (LAN) Settings of Internet Options:
a. Work with your IT team to bypass [::1] addresses in the local proxy.

Hope this help
Like Show 0 Likes(0)

Actions
3. Re: Error when connecting to Google Sheets (Tableau 10.5.6)

Benny Magnus Jul 27, 2018 6:04 AM (in response to kumar bharat)

Hi Bharat,

I'm indeed following the steps which are described in the links you gave.
It always goes wrong after I clicked 'Allow'.

Kind regards,
Benny
Like Show 0 Likes(0)

Actions
4. Re: Error when connecting to Google Sheets (Tableau 10.5.6)

Benny Magnus Jul 27, 2018 6:04 AM (in response to Sebastian Sofariu)

Hi Sebastian,

Thanks for the advice. Apparently I have an automatic proxy setup that uses a setup script. I contacted the IT team and let you know if this fixed the issue.

Kind regards,
Benny
Like Show 0 Likes(0)

Actions
5. Re: Error when connecting to Google Sheets (Tableau 10.5.6)

Benny Magnus Aug 7, 2018 7:47 AM (in response to Sebastian Sofariu)

Hi all,

Not 100% sure if it's due to proxy settings but for some reason it works if you use Internet Explorer as browser instead of Google Chrome.
The live connection also works as it should after publishing the dashboard.

Kind regards,
Benny
Like Show 0 Likes(0)

Actions
6. Re: Error when connecting to Google Sheets (Tableau 10.5.6)

Suraj Kumar Sep 26, 2018 10:21 PM (in response to Benny Magnus)

Hi Benny,

1. Just try to go through this link. If this helps you, please let me know.
Resources | Tableau Public

2. Try checking you google account, where google may be blocking this request to connection in security and privacy section.

Regards,
Suraj
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
7. Re: Error when connecting to Google Sheets (Tableau 10.5.6)

Benny Magnus Sep 27, 2018 6:56 AM (in response to Suraj Kumar)

Hi Suraj,

The connection works fine when using browsers Internet Explorer or Microsoft Edge. For some reason it doesn't work for me with Google Chrome.
It could be a setting in Google Chrome that's causing this but to be honest I've no idea which settings in the security section to look at...

FYI - I experienced the same connection issue when connecting to Box. I had to set Microsoft Edge as my standard browser before I could connect with my Box account. Not ideal as I was used to work with Google Chrome but it's an easy workaround that works perfectly.

Kind regards,
Benny
Like Show 0 Likes(0)

Actions
8. Re: Error when connecting to Google Sheets (Tableau 10.5.6)

Suraj Kumar Sep 27, 2018 7:46 AM (in response to Benny Magnus)

Ok Benny,
Still try trouble shooting as sometimes google chrome also blocks flash by default or open dialog block. So, those troubeshooting from browser might help.

Still, You have this workaround. Sounds Good.
Like Show 0 Likes(0)

Actions