SAP Knowledge Base Article - Preview

3697328 - During PowerBI with a direct query to HANA, the user-sessions are not closed/terminated

Symptom

  • When running reports in PowerBI with a direct query to HANA (using HANA ODBC), hundreds of user-sessions are created in HANA and these are not terminated, even the configured idle timeout does not clear the ephemeral ports on the gateway.


Read more...

Environment

SAP HANA, platform edition

Product

SAP HANA, platform edition 2.0

Keywords

idle timeout, HANA ODBC, Microsoft, direct query, PowerBI, user-session, terminated, closed, ephemeral ports , KBA , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.