KNOWLEDGE BASE

Boolean Values in OData Imported as Null


Published: 06 Feb 2021
Last Modified Date: 24 Mar 2021

Issue

Values in a Boolean column in OData may be imported incorrectly as Null in Tableau Desktop.

Environment

  • Tableau Desktop 2020.2 and newer
  • Odata

Resolution

As possible workarounds, try the following options:

Option 1

Connect to OData data source using Tableau Desktop 2020.1 instead.

Option 2

  1. In the Data pane, change the data type of the Boolean fields to String: Click the icon to the left of the field name, and then choose String from the drop-down list.
  2. Refresh the extract: Right-click the data source and select Extract > Refresh.
  3. Create Boolean calculated fields based on the String fields.

Cause

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