Text or CSV File Data Source Does Not Return All Rows

Published: 25 Sep 2014
Last Modified Date: 23 Apr 2020


When you connect to a text file or CSV data source, the number of records reported by Tableau Desktop might be fewer than the number of rows in the text or CSV file.


  • Tableau Desktop
  • Tableau Prep
  • Text Files


Resolution for Possibly Cause 1 (please refer to Root Cause)

Option 1: 

Save the CSV file with ANSI, OEM, UTF-8, or UTF-16 encoding.

Option 2:

  1. In Tableau Desktop, right click the data source in the Data pane and select Edit Data Source...
  2. In the join area, click the drop-down arrow on the table name and then select Text File Properties
  3. For Character Set, select the encoding used for the CSV file. ​
  4. For Text Qualifier, select the character used to mark where text begins and ends
Resolution for Possibly Cause 2

Make sure field separator is not displayed in data value


Possibly Cause 1
The file is saved with an encoding that does not match the character set setting of the connection, or the Text Qualifier is set incorrectly.

Possibly Cause 2
There are values including field separator (ex: using comma as separator but the number is displayed as 123,456)
Did this article resolve the issue?