Report Portal

"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."



Tags: excel, management


2007-2015 VidasSoft Systems Inc.