KNOWLEDGE BASE

Error "Type of data source is not in the list of types allowed for refresh" When Refreshing Published Extract


Published: 21 Jan 2020
Last Modified Date: 21 Jan 2020

Issue

When trying to refresh a published extract, the job may fail with the following reason:

Type <data source name> of data source is not in the list of types allowed for refresh. Refresh skipped. (errorCode=60007)

Environment

  • Tableau Online
  • Cloud data source (e.g. Google Sheets, BigQuery)

Resolution

  1. Follow the steps in Replace Data Sources to create a new connection to the cloud data source, which would also copy over the fields (such as calculated fields, groups and sets) that you have created in the workbook.
  2. Create an extract by right-clicking the new data source in the Data pane, and selecting Extract Data.
  3. Check that the icon in the Data pane shows that workbook is connected to an extract that still references underlying the cloud data source: User-added image
  4. Publish the data source to Tableau Online. 
Did this article resolve the issue?