Excel addin: service has forbidden you to perform the operation GET on this endpoint (VBAFE-00116)
Summary:
Hi, we have an issue for the Excel add-in to access VB
Using our admin account, we can successfully run Excel add-ins against our VB app.
However, for a user account, even a user (set up as ServiceUser) who can successfully access the published Development deployment, has all actions on the Excel add-in fail (either on the source or published versions of the Excel), with the error message: The service has forbidden you to perform the operation GET on this endpoint: the-table-name.... Please contact an administrator to review your permissions. (VBAFE-00116)
We have checked Settings->Business Objects->Security "Enable basic authentication for business object REST APIs" and republished the development deployment with a new version and refreshed the Excel catalog. But we get the same error. Could i please check ... what additional security settings are needed for users who can access the deployed app to also access via Excel ?