3309711 - Accessing Live Data Connections of an SAC tenant fails because of insufficient permissions

Accessing Live Data Connections of an SAC tenant fails because of insufficient permissions.

In current AO versions, the messages below are displayed:
----------------------------------------------
Analysis Office currently is not able to establish a connection.:
Failed connecting to '...': The remote server returned an error: (401) Unauthorized.
Server response:{"status":401,"message":"HTTP 401 Unauthorized"}
----------------------------------------------

After installing the version mentioned in SAP Note 3307594, the warning below is displayed instead:
----------------------------------------------
[7c4e-c8f9-ae] Couldn't access Live Data Connections because of insufficient permissions. Please see SAP Note 3309711 for further details. (ID-114228):
----------------------------------------------

SAP Analysis for Microsoft Office

The user has insufficient permissions.

• If the user should not be able to access Live Data Connections, this warning message can be avoided by turning off the AO functionality "Enable Live Data Connections" for the specific SAC tenant:

  
  
  

• If the user should have access to the Live Data Connections, the SAC tenant administrator needs to ensure that the user is assigned to a role that has the "Read" permission for "Connection". To check if a role has the required permission:

1. Log on to the SAC tenant with an administrator account;

2. Go to Security -> Roles;

3. Select the role which the affected user has;

4. Check if the role is assigned to the Read permission of Connection:
   
   
   

SAP Note 3307594 ("AO: SAC - Logon shows error message when not having permission to access Live Data Connections")

7c4e-c8f9-ae, ID-114228, warning, live data, couldn't access Live Data Connections because of insufficient permissions , KBA , BI-RA-AO-XLA , Excel Addin , Problem