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: 28 Jul 2020

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?