SAP Knowledge Base Article - Public

3511880 - Error occurs when connecting SAP BW or SAP S/4HANA Tunnel type Live connection in SAC add-in for Microsoft Excel

Symptom

  • In SAC add-in for Microsoft Excel, error occurs when connecting a SAP BW or SAP S/4HANA Tunnel type Live connection.
    ------------------------------------------------------------------------------------------------------------
    An error occurred while loading the data sources of system <systemname>. Therefore, no data sources can be shown. 
    ------------------------------------------------------------------------------------------------------------

  • When trying to insert any model using same live connection, then following error is displayed.
    ------------------------------------------------------------------------------------------------------------
    An error occurred while inserting <modelname>. 
    ------------------------------------------------------------------------------------------------------------



The issue only occurs in SAC add-in for Microsoft Excel, there is no issue connecting the same connection in SAC in browser.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental". 

Environment

SAP Analytics Cloud, add-in for Microsoft Excel

Reproducing the Issue

  1. In SAC add-in for Microsoft Excel, sign in to SAC tenant.
  2. Click 'Add Table' button.
  3. In 'Select Data Source' screen, select a SAP BW or SAP S/4HANA live connection of type Tunnel and get the error.

Cause

The connection attempt from SAC add-in for Microsoft Excel via Tunnel live connection has no valid user and password saved.

Resolution

The preferred authentication method for Live Data Connection is "SAML Single Sign On".

In case the Live Data Connection is configured with authentication method "User Name and Password", then the option "Save this credential for all users on this system" must be checked.

The SAC add-in for Microsoft Excel does currently not support manual authentication, so the user is never prompted a dialog for manually providing user and password. That's why the used Tunnel Live Data Connection must have a valid user and password saved in it.

To check option "Save this credential for all users on this system" in the Live Data Connection, follow the steps below:

  1. Log into SAC tenant in the browser.
  2. Open the edit screen of the corresponding Tunnel Live Connection.
  3. Maintain a valid User and Password and ensure checkbox "Save this credential for all users on this system" is checked.
  4. Click 'OK' button to save the change in connection.

Keywords

SAC addin for Excel, SAC addin for Microsoft Office, SAP Analytics Cloud, BW live connection, S4HANA live connection, S/4HANA live connection , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem

Product

SAP Analytics Cloud, add-in for Microsoft Office all versions