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: