We have an excel spreadsheet (Office 365) connecting to an SQL Server Analysis Service (SSAS) cube. The data is being pulled to a Pivot table in the excel spreadsheet. The spreadsheet used to work fine in the past and suddenly having the following Errors\Issues.
1) We couldn't get data from an external data source. Please try again Later.
If the problem persists, please contact the administrator for the external data source.
Here is the error message that was returned from the analysis server named <XXXXXXX>
Server: The current operation was cancelled because another operation in the transaction failed.
2) We couldn't get data from an external data source. Please try again Later.
If the problem persists, please contact the administrator for the external data source.
Here is the error message that was returned from the analysis server named <XXXXX>
An Error was encountered in the transport layer
This is not allowing the pivot table to refresh.
Any help would be appreciated.