Excel add-in fails for ServiceUser: Service has forbidden you to perform the GET (VBAFE-00116)
Summary:
Excel add-in fails only for ServiceUser (it works for admin) with error: 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)
Content (please ensure you mask any confidential information):
hi! We can successfully use the Excel add-in with our VB admin account, but it fails for users with error:
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)
Our admin account has the standard ServiceAdministrator application, while the users have the standard ServiceUser role. The users can run the app successfully via the Shared or Published deployments, but cannot access app data via the Excel add-in (v4 and v3.8).