KNOWLEDGE BASE

Error: "Errors occurred while loading the data source" When Attempting to Connect to an Excel File that Contains Slicers


Published: 22 Aug 2017
Last Modified Date: 24 Aug 2017

Issue

When trying to connect to an Excel file containing slicers, the following error occurs:

Errors occurred while loading the data source

Environment

  • Tableau Desktop
  • Excel

Resolution

Option 1

Remove all slicers from the Excel file. Then try to connect to the Excel file again. For more information about how to remove the slicer, see Use slicers to filter PivotTable data.


Option 2

In Tableau Desktop on Windows, connect to the Excel file using the Microsoft Jet-based connection: 
  1. In the Open dialog box
  2. Click the Open drop-down menu
  3. Select Open with Legacy Connection.
Did this article resolve the issue?