KNOWLEDGE BASE

Fewer Records in CSV File Legacy Connection Compared to Native Connector


Published: 23 Mar 2017
Last Modified Date: 21 Apr 2019

Issue

When connected to a CSV file, the Legacy Connection is returning fewer records than expected.

Environment

  • Tableau Desktop earlier than 2019.1 (See note in Additional Information)
  • Text Files

Resolution

  1. On the Data Source tab, right click the table and select Text File Properties.
  2. Select a different character set or delimiter.

Cause

Text File Properties were set incorrectly. 
 

Additional Information

Note: Starting in Tableau 2019.1, you can no longer create a new Legacy Excel or Text connection. Existing workbooks created with these legacy connections will continue to work until 2019.2, when all support for legacy connections will be removed. See the Legacy Connection Alternatives document in Tableau Community for alternatives to using the legacy connection.



Discuss this article... Feedback Forum
Did this article resolve the issue?