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