KNOWLEDGE BASE

One or More Views on the Dashboard Are Blank After First Extract Refresh from MS SQL Server Database


Published: 09 Apr 2014
Last Modified Date: 14 Sep 2015

Issue

When viewing a dashboard or view published to Tableau Server, and using a connection to MS SQL Server, the dashboard might appear blank after the first data extract refresh.

Environment

  • Tableau Server
  • MS SQL Server

Resolution

  1. Download correct MS SQL Server driver from Drivers & Activation page.
  2. Install driver on all computers running Tableau Server.

Cause

If there are no supported SQL Server drivers installed, Tableau Server reverts to the Windows default SQL driver. This driver works in most cases, however does not support some newer field types and advanced features used by newer versions of MS SQL server.

Additional Information

One of the most popular issues is Date field type: this type is not supported by default SQL driver and automatically converted to default String type by driver. Temporary workaround in this case is to use "Change Data Type" menu in Tableau Desktop to change Date fields in Date&Time fields.
Did this article resolve the issue?