SAP Knowledge Base Article - Public

3249585 - Import from File Server or Excel not loading in SAP Analytics Cloud (SAC)


  • Data import via MS SQL Server doesn't load/hangs
  • Data import via excel file doesn't load/hangs in SAP Analytics Cloud (SAC)


SAP Analytics Cloud (SAC)

Reproducing the Issue

  1. Go to Modeler
  2. Attempt import via File Server or Excel file


The issue of the import hanging is due to a particular query which causes poor performance.

For example, a WHERE NOT IN condition may cause poor performance.


Rewriting the query to improve performance.

For the example above, removing the NOT operator from the WHERE clause will improve performance. 

See Also

SAC, Error, Issue, Data, Unable, Connection, Connector, Connect, Import, Live, Acquisition, Setup, Model, Failure, Stopped, Loading


KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem


SAP Analytics Cloud 1.0