Skip to main content

Direct Query limitations

The following section describes the limitations of Direct Query.

The following limitations apply when using and creating Direct Query apps:

  • Qlik Sense Mobile SaaS does not support Direct Query.

  • Direct Query capabilities are dependent on the capabilities of the underlying cloud databases and SQL pushdown.

  • Direct Query performance is heavily affected by the performance of the underlying data source.

  • What is supported in Direct Query mode might be different in each app depending on the data connection type. Each database might treat the execution of queries differently.

  • It is not possible to use Qlik Data Gateway - Direct Access data connections in Direct Query.

  • Security is handled by the database.

  • Direct Query app type can only be selected for databases where Direct Query mode is supported.

  • To use Direct Query on a database, you need to have permission to read from the database.

  • To use Direct Query on a data connection, you need to have the Can consume data permission in the space where the data connection resides.

  • Interception and local execution of some operations will only follow the caching paradigm, which the user must turn on.

  • The following activity center actions are not supported:

    • Impact analysis

    • Open without data

    • Evaluate performance

    • Reload

    • Schedule reload

  • Direct Query apps can be published to managed spaces, but users in the managed space must have access to the data connection used by the Direct Query app.

  • There is a 1 million row limit on what can be returned in a single query to an underlying database.

  • The green, white and grey associative model is not supported. Because of the limitations of SQL query-based modelling, data is filtered rather than selected. For more information, see The associative selection model.

  • Sorting options are not supported in filter pane visualizations. Default sorting is applied automatically.

  • Direct Query filter panes do not indicate excluded values in gray. For more information, see Selection states.

  • Visualization extensions are not supported.

  • Embedding app content is not supported.

  • Sharing and downloading app content is not supported.

  • Reporting capabilities, including the Qlik Reporting Service value-add features and subscription reports, are not supported in Direct Query apps.

  • Context sensitive help is not available in the expression editor for Snowflake functions.

  • The following field search capabilities are not supported:

    • Fuzzy search

    • Compound search

    • Implicit word-based search or word-based search expressed with "^"

    • "-" and "+" symbols indicating additional search semantics instructions

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!