KNOWLEDGE BASE

Text or CSV File Data Source Does Not Return All Rows


Published: 25 Sep 2014
Last Modified Date: 20 Dec 2016

Issue

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.

Environment

  • Tableau Desktop
  • Text Files

Resolution

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. 
  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.
 

Cause

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.
Did this article resolve the issue?