KNOWLEDGE BASE

Google Sheets Data Generated from GOOGLEFINANCE() is NULL


Published: 16 Nov 2016
Last Modified Date: 21 Jun 2018

Issue

When connecting to a Google Sheet that uses the function GOOGLEFINANCE(), then those fields and any fields that reference those fields are NULL, aka blank, in Tableau Desktop.

 

Environment

  • Tableau Desktop
  • Google Sheets
  • Google Finance formulas

Resolution

Create a second Google Sheet that imports the Google Finance data using the IMPORTRANGE() function, and then connect to the second Google Sheet.

For more information about this Google function, please see IMPORTRANGE.

Cause

Tableau Desktop is not able to import these Google Finance tables directly via Google Sheet connector now. This behavior is due to a limitation of Google Sheets and is not specific to Tableau Desktop.

Additional Information

For more information about this topic, see Google Finance Data in Tableau 10 using Google Sheets Connection, please note that this information is provided by a third-party website. While we make every effort to keep references to third-party content accurate, Google options might change without notice. For the most up to date information, please consult Google documentation, and for assistance with the product, contact Google technical support.
Did this article resolve the issue?