Forum Discussion

btfergie's avatar
btfergie
Helper I
3 years ago

[DataSource.Error] AnalysisServices: The connection either timed out or was lost.

I am getting this message on Refresh or Apply Queries:  OLE DB or ODBC error: [DataSource.Error] AnalysisServices: The connection either timed out or was lost.  This happens about 90% of the time.  I...
Need Help
GilbertQ's avatar
GilbertQ
Super User
3 years ago

Hi btfergie 

 

What I would suggest doing is having SQL  Profiler running when the refresh is taking place. You should be able to see if there is an error in your SSAS and what is the cause.

 

It could be memory or CPU pressure that is happening at the same time you are trying to refresh.

Related content