KNOWLEDGE BASE

Error "Operation on field (...) is not permitted" Using Sets in Calculated Fields with MS Access


Published: 16 Mar 2017
Last Modified Date: 23 Mar 2017

Issue

An "Operation on field <field name> is not permitted" error appears when trying to use a set in a calculated field.

Environment

  • Tableau Desktop 
  • Microsoft Access

Cause

Access does not support Case... When statements, and this query is required to include Sets in calculated fields. 

 
Did this article resolve the issue?