Unable to Open File "Compressed Stream" in Excel Power Pivot and Analysis Services (SSAS)

Overview of the error message

This error happens in Excel when you try to refresh some data from SQL Server Analysis Services (SSAS) and the refresh returns the error "Unable to Open file compressed stream". Often this workbook is a using PowerPivot.

 

Solution

This solution fixes the issue most of the time.

In SQL Analysis Services:

  1. Open Microsoft SQL Server Management Studio
  2. Connect to the instance of Analysis Services (SSAS)
  3. Right click on the server node
  4. Click Properties
  5. Click General
  6. Find and modify "Network \ Responses \ Enable Compression" to FALSE

image

More info

Microsoft has this information as well about this error:https://support.microsoft.com/en-us/kb/2735237

Their recommended fix is to ‘Try the refresh the PowerPivot workbook again’