"We couldn't get data from the external source" refreshing data from SQL Server in Excel
Have you ever experienced an issue where you are working in an Excel file, connected without a problem to your SQL Server cube data, but after letting the application sit idle for a time (ex. 3-6 minutes), you get an error similar to the one below when you come back and try to refresh the connection again or click on a slicer?
ERROR: "We couldn't get data from the external data source. Here's the error message we got: An error was encountered in the transport layer."