Error "No compatible data sources available" Appending from Data Source
Published: 01 Aug 2014 Last Modified Date: 13 Apr 2017
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
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.
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.
In Tableau Desktop, select Extract > Append Data from File.