ODBO - Internal Error Occured: The remote server returned an error: (401)

Summary

This article provides troubleshooting tips related to receiving the error:

Internal Error Occured: The remote server returned an error: (401)

Symptom

Excel displays the above error.

Causes

If authentication for Jaspersoft OLAP Server is enabled, you will need to provide the username and password.

Resolutions

Enable the Save password in file option of Excel when storing the connection information

Also See

Jaspersoft ODBO Connect User Guide - Chap. Authentication Notes).