Disable Direct Query

Disable Direct Query

To Disable Direct Query in a dataset in the dashboard, follow the steps below.

  1. Open the dashboard in edit mode. Refer to Editing the Dashboard. The dashboard is displayed.
  2. In the Data Pane, click the ellipsis corresponding to the dataset, and then click Disable Direct Query from the listed option.


    Disable Direct Query window appears.

  3. Select OK and Save the Dashboard.


    Direct Query is disabled for the dataset in the dashboard. Now, Cache files will be generated from the dataset, and widgets will retrieve data from the cache

    • Related Articles

    • Direct Query

      "Direct Query" is the term that usually refers to a feature in Data Visualization. It fetches the real-time data from the underlying data source. The direct query option is useful when dealing with large datasets that are unable to import efficiently ...

    • Enable Direct Query

      To Enable Direct Query for a dataset in the dashboard, follow the steps below. Open the dashboard in edit mode. Refer to Editing the Dashboard. The dashboard is displayed. If required, add a new dataset to the dashboard. Refer to Adding a dataset to ...

    • Snowflake

      Creating Snowflake Dataset To create a snowflake dataset, follow the steps 1 and 2 given in Creating SQL Dataset. The following figure shows the Product Selection page. The Data Connect page for choosing your dataset type is displayed. From the RDBMS ...

    • Databricks

      Creating Databricks Dataset To create a Databricks dataset, follow the steps given below. On the home page, click the Create icon (). The Product Selection page is displayed. Hover over the Data Connect tile and click Create Dataset. The following ...

    • MongoDB

      Creating MongoDB Dataset To create a MongoDB dataset, follow the steps given below. On the home page, click the Create icon ( ). The Product Selection page is displayed. Hover over the Data Connect tile and click Create Dataset. The following figure ...