KNOWLEDGE BASE

Error "Missing required context variable: username" When Editing a Google Sheets Data Source


Published: 06 Jun 2017
Last Modified Date: 07 Aug 2017

Issue

When attempting to modify a Google Sheets data source in Tableau Public 10.2 and 10.3, the following error message might occur: 

"Missing required context variable: username"

Environment

  • Tableau Desktop Public Edition 10.2 and 10.3
  • Google Sheets

Resolution

Option 1

Reconnect to the data source and replace the original data source with the new connection. For more information, see Replace Data Sources
in Tableau Help.

Option 2

  1. Open Tableau Public Desktop, go to File > Open from Tableau Public...
  2. Enter your credentials.
  3. Choose the workbook.
  4. Then right-click the data source > Edit Data Source...

Cause

Tableau Public is behaving as designed. To protect the privacy of users, the email of the owner of the Google Sheet data source is removed. Therefore, the error occurs when you try to edit the data source.
Did this article resolve the issue?