This article provides troubleshooting tips related to receiving the error:
Internal Error Occured: The remote server returned an error: (401)
Excel displays the above error.
If authentication for Jaspersoft OLAP Server is enabled, you will need to provide the username and password.
Enable the Save password in file option of Excel when storing the connection information