Enable Direct Query

Enable Direct Query

To Enable Direct Query for 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. If required, add a new dataset to the dashboard. Refer to Adding a dataset to the dashboard.
  3. In the Data Pane, click the ellipsis corresponding to the dataset, and then click Enable Direct Query from the listed option.


    Enable Direct Query window appears.

  4. Select OK and Save the Dashboard. Direct Query is enabled for the dataset in the dashboard.


Notes

  • If you select the "Disable Cache" option while creating the dataset, the "Enable Direct Query" option will not be available in the dashboard and the dataset will work as a Direct Query.
  • If you select the "Enable Direct Query" option, the "Add Cached Calculated Column" option will not be available for the respective dataset in the dashboard.
  • If you select the "Disable Cache" option while creating the dataset, the "Add Cached Calculated Column" option will not be available for the respective dataset in the dashboard.
  • "Cached Calculated Column" will behave as a calculated column when the respective dataset is enabled with Direct Query in the dashboard or the Disable Cache option is enabled in the dataset.

    • 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 ...

    • Disable Direct Query

      To Disable Direct Query in a dataset in the dashboard, follow the steps below. Open the dashboard in edit mode. Refer to Editing the Dashboard. The dashboard is displayed. In the Data Pane, click the ellipsis corresponding to the dataset, and then ...

    • 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 ...

    • 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 ...

    • 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 ...