KNOWLEDGE BASE

Query with Continuous Date axis set to Hour or more Granular shows no Underlying Data


Published: 20 Jun 2018
Last Modified Date: 20 Jun 2018

Issue

When connecting to Oracle, views showing a continuous date field set to anything smaller than DAY (HOUR or MINUTE or SECOND) may show no underlying data. Additionnally the following error might occur: 

"Exporting data failed 
The data source can't be exported because it doesn't contain any records. Adjust data source or extract filters and then try again." 

Environment

  • Tableau Desktop
  • Oracle

Resolution

Option 1

Upgrade to Tableau Desktop version 10.3.12, 10.4.8, 10.5.5, 2018.1.2 or a later version. For more information, see Upgrading Tableau Desktop in Tableau Help.

Option 2

As a workaround, remove all selection from the view and navigate menu Analysis - View Data.

Cause

This behavior is related to a known issue (ID: 769287) which has been fixed in a recent release of Tableau Desktop. 
Did this article resolve the issue?