KNOWLEDGE BASE

Error "An error occurred while communicating with data source ... DataServiceFailure" When Loading a Worksheet Connected to a Published data source


Published: 21 Feb 2018
Last Modified Date: 09 Dec 2018

Issue

When loading a worksheet connected to a published data source, the following error may occur:
 
An error occurred while communicating with data source 'XXXXXXXXXX'. The connection to the data source might have been lost.
MEASURE expressions must be aggregate or depend only on GROUPBY columns.
prepare.xml
DataServiceFailure

Environment

  • Tableau Desktop 10.3.4
  • Tableau Server
  • Windows 10

Resolution

As a Tableau Server Administrator, upgrade to Tableau Server 2018.1.1, 10.5.4 or a later version. For more information, see Upgrading Tableau Server in Tableau Help. 

Cause

This behavior is related to a known issue (ID: 741875) which has been fixed in a recent release of Tableau Server. 
Did this article resolve the issue?