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

Published: 01 Aug 2014
Last Modified Date: 08 Sep 2018


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.


Tableau Desktop 8.2 and later versions


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?