Error "incorrect Data Type" Is Returned When Opening Certain Views In Tableau Cloud

Published: 16 Sep 2019
Last Modified Date: 08 Jul 2022


After the 2019.3 release, when accessing certain views with a live connection to a cloud-hosted data source the following error occurs:

Unknown Server Error TableauException: Incorrect data type


  • Tableau Cloud 2019.3
  • Live connection to cloud-hosted data
  •  ceiling functions


To work around the issue, use the below options.

Option 1 Edit the [Time Of Day] calculation to divide (and/or modulo) by 60.0 (which is a real) instead of 60 (which is an int).

Option 2 Extract the data source and republish it to Tableau Cloud. 

This issue has been resolved on Tableau Cloud. 
Did this article resolve the issue?