Errors:

1. An error encountered in the transport layer

2. Errors in the OLE DB provider. An error occurred while loading the connection dialog box component for prompting

Image

Image

When trying to import data from ssas cube to excel sheet I got this error

Solution: Re-installing Analysis Services OLE DB drivers will resolve this issue.