Loading
Ongoing maintenance for Salesforce HelpRead More
Salesforce Enforces New Security Requirements in Summer 2026Read More

Error "[Microsoft][ODBC Driver 17 for SQL Server]Restricted data type attribute violation" connecting to SQL Server Stored Procedures after Upgrade

Publish Date: Jul 13, 2026
Description

Issue

After upgrading Tableau Server or Tableau Desktop to version 2023.2.9, 2023.3.6, 2024.2, 2025.1, or 2025.3 and later, workbooks that connect to Microsoft SQL Server (or Azure SQL Database) via Stored Procedures may fail to load.

The following error message is displayed:

[Microsoft][ODBC Driver 17 for SQL Server]Restricted data type attribute violation

[Microsoft][ODBC Driver 18 for SQL Server]Restricted data type attribute violation

You may also see additional details such as:

Field '[FieldName]' domain cannot be calculated correctly.

Environment

  • Tableau Desktop 2023.2.9, 2023.3.6, 2024.2, 2025.1, 2025.3 and later
  • Tableau Server (corresponding versions)
  • Microsoft SQL Server or Azure SQL Database
  • Connection type: Stored Procedures

Cause:

This issue is caused by a change in the Query Pipeline (QP) component introduced in past maintenance releases.

When processing results from a Stored Procedure, Tableau incorrectly attempts to bind certain data types (such as DATE or String types) as Integers (BigInt). The SQL Server ODBC Driver rejects this implicit conversion request (e.g., DATE to Integer) with a "Restricted data type attribute violation" error.

Resolution

To resolve this issue, disable the QueryPipeline_UseStoredProcRelationOp feature flag.

Option 1: For Tableau Server

  1. Open a command prompt (Windows) or a terminal (Linux) on the Tableau Server node (initial node).
  2. Run the following TSM command to disable the feature flag: 
    tsm configuration set -k features.QueryPipeline_UseStoredProcRelationOp -v false
  3. Apply the changes (This will restart Tableau Server): 
    tsm pending-changes apply

Option 2: For Tableau Desktop

Close Tableau Desktop and launch it from the command line with the override flag.

Windows:

  1. Open Command Prompt (cmd.exe) or PowerShell.
  2. Run the executable with the flag (adjust the path based on your installed version): 
    "C:\Program Files\Tableau\Tableau 20xx.x\bin\tableau.exe" -DOverride=QueryPipeline_UseStoredProcRelationOp:off

Mac:

  1. Open Terminal.
  2. Run the application binary with the flag (adjust the version in the path): 
    /Applications/Tableau\ Desktop\ 20xx.x.app/Contents/MacOS/Tableau -DOverride=QueryPipeline_UseStoredProcRelationOp:off
Additional Resources

This behavior is currently under investigation by Salesforce Engineering for a permanent fix in a future release.

Knowledge Article Number

005232928

 
Loading
Salesforce Help | Article