KNOWLEDGE BASE

Error "No compatible data sources available" Appending from Data Source


Published: 01 Aug 2014
Last Modified Date: 14 Aug 2017

Issue

When you try to append data by selecting  Extract Append data from Data Source, the following error might occur:

No compatible data sources available in this workbook.

Environment

Tableau Desktop 8.2 and later versions

Resolution

Option 1

If the workbook was created in Tableau Desktop 8.1 or an earlier version, use the Legacy option to open the file being appended.
  • In Tableau Desktop, browse to your data file, click the drop-down arrow on Open, and then select Open with Legacy Connection.

Option 2

  1. Name the Excel sheet that you are trying to append exactly as the original Excel sheet that you connected to. For example, if you initially connected to the sheet January in an Excel workbook named Primary, name the sheet with the data you want to append January.
  2. In Tableau Desktop, select ExtractAppend Data from File.
Did this article resolve the issue?