KNOWLEDGE BASE

Error "[SQL Server]Invalid column name" Refreshing Data


Published: 21 Dec 2015
Last Modified Date: 24 Apr 2017

Issue

When refreshing data in a view, the following error might occur:

[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'Topic'. [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'Topic'. [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'CommunicationNeeded_Numeric'. [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'CommunicationNeeded_Percent'.\n[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared."

Environment

  • Tableau Server 9.1.1
  • Windows
  • MS SQL Server

Cause

This behavior is a known issue which has been corrected in more recent versions.
Did this article resolve the issue?