KNOWLEDGE BASE

Data Keeps Loading in the Input Step or Error "Tableau Prep Stopped Running Because an Underlying Process Stopped Unexpectedly" Occurs When Connecting to Google BigQuery


Published: 26 Sep 2022
Last Modified Date: 27 Sep 2022

Issue

When connecting to Google BigQuery from Tableau Prep, after adding the table from the data pane, the data keeps loading in the input step and won't complete. 
The loading status is between "Validating flow and generating schema..." and "Running flow..." like the image below.
User-added image

Or the below error occurs after loading the data for a while. 
Tableau Prep stopped running because an underlying process stopped unexpectedly. If this problem continues, try reinstalling the product.
User-added image
 

Environment

  • Tableau Prep Builder 2022.2, 2022.1, 2021.4
  • Google BigQuery
  • macOS
  • Windows

Resolution

Please use the below workarounds to avoid this issue.

Option 1
After adding the Input step, move to the [Data Sample] tab, and select [Use all data] or set a [Fixed number of rows].
User-added image

If you are using a large table, this method might take a long time to load and process the data. In this situation, please refer to Option 2.

Option 2
After selecting a Project and Dataset, Double-click Custom SQL located at the bottom left of the pane.
An input step should be automatically added. In the Custom SQL dialog box, enter a query using the syntax below and then click Run.
* No need to change the option in the [Data Sample] tab in this method.
SELECT * FROM `project-id.dataset_name.table_name`
User-added image
User-added image

Note: The Custom SQL option will not be displayed until a dataset is selected.  The Custom SQL option can be displayed by selecting a random project and dataset. 

Cause

This issue is under investigation.
Did this article resolve the issue?