KNOWLEDGE BASE

Unable To Import Text File Which Contains Only One Row


Published: 28 Aug 2018
Last Modified Date: 29 Aug 2018

Issue

When trying to import a text file which contains only one row, the following error message occurs.
 
An error occurred while communicating with the data source.
Unable to connect to the file "[<File Name>]". Check that the file exists and that you have sufficient access privileges for it.
Text file has no lines
The table "[TableauTemp].[<File Name>]" does not exist.

Environment

  • Tableau Desktop
  • Text Files

Resolution

Add a header row to the text file.

Cause

Tableau Desktop always reads the first row as a header. The result is, that Tableau Desktop considers the text file as not containing any rows.
Did this article resolve the issue?