Categories
Computers

Tableau’s 3834D197 error: Pivot Tables in Google Sheets

Today’s story is a little note to self, something to remind me when I next hit the same issue.

At $DAYJOB I was just working on some Google Sheets-backed dashboards using Tableau, when the team hit the following error message:

A tableau error dialog, saying: Unable to complete action Bad Connection: Tableau could not connect to the data source. Error Code: 3834D197 Errors occurred while loading the data source. With a Go to Support link in the bottom left, and a "Copy Error Message" on the bottom right.
Tableau error message for the code 3834D197

It says:

Unable to complete action
Bad Connection: Tableau could not connect to the data source.
Error Code: 3834D197
Errors occurred while loading the data source.

While debugging this, there were actually two aspects to take into account, that complicated things: one is the source of the error, and the other is Tableau’s behaviour when encountering the error. Both are good to keep in mind for future development.