CODEWITHSUNDEEP
extracttableau-apidatasource
Chamila Maddumage
Chamila Maddumage

Reputation: 3866

An error occurred while attempting to save the workbook in Tableau

I am using Tableau desktop to create a workbook. When I am going to publish it to the tableau online server I am getting following error.

The tableau server you are publishing to does permit external database connections. Use the Data menu to create and extract for the following data sources.

Data Extract Required

"My data source name"

I have created a data source which get data from SQL on premises database. Can anyone give me a solution for this.

Upvotes: 2

Views: 4052

Answers (2)

rdugge
rdugge

Reputation: 348

Out of the box. Tableau Online only allows direct connections to specific cloud data sources. If you want to refresh your extract to on-premises data sources, you'll want to leverage the Tableau Bridge client

Upvotes: 1

Gonçalo Peres
Gonçalo Peres

Reputation: 13582

As the warning says, one needs to create an Extract.

Though there are several options in your Tableau workflow for creating an extract, the primary method is described below.

  1. After you connect to your data and set up the data source on the Data Source page, in the upper-right corner, select Extract, and then click the Edit link to open the Extract Data dialog box.

Tableau Data Source Connection - Extract

  1. (Optional) Configure one or more of the following options to tell Tableau how to store, define filters for, and limit the amount of data.
  2. When finished, click OK.
  3. Click the sheet tab. Clicking the sheet tab initiates the creating of the extract.
  4. In the subsequent dialog box, select a location to save the extract, give the extract file a name, and then click Save.

For more information on how to Extract Data, check the official documentation.

Upvotes: 2

Related Questions