KNOWLEDGE BASE

Error: "not a sql data connection, cannot construct query function" when publishing a workbook to Tableau Online


Published: 29 Oct 2018
Last Modified Date: 12 Nov 2018

Issue

When publishing a workbook to Tableau Online, the following error may occur:

An error occurred when publishing the workbook.
not a sql data connection, cannot construct query function
Unable to create extract

Environment

Tableau Online

Resolution

Review the list of data source connections and close any empty connections. An empty data source will typically be marked with a red exclamation point in the data pane:

Example of empty data source showing red exclamation point

Cause

For workbooks with live connections to on-premise data sources, an extract must be created during publishing. An extract cannot be created for an empty data source connection, as it will result in an error and a failed publishing attempt.
Did this article resolve the issue?