KNOWLEDGE BASE

Error: "Errors occurred while loading the data source" When connecting to Excel files


Published: 10 Aug 2017
Last Modified Date: 19 Nov 2017

Issue

When connecting to Excel files, the following error might occur in Tableau Desktop:

"Errors occurred while loading the data source"

Additionally, you notice that this error occurs with several Excel files, but not with all of them.

Environment

  • Tableau Desktop
  • Excel

Resolution

To resolve this issue, please follow the steps below:
  1. Open the affected Excel file.
  2. Copy the whole data.
  3. Paste the data into a new Excel file.
  4. Save this new Excel file.
  5. Connect Tableau Desktop to this new Excel file.
The error should no longer occur and the connection should be successful.

Cause

The Excel file is corrupted.
Did this article resolve the issue?