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.


(info)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 ...

    • Adding A Custom Query

      To add a Custom Query while creating a dataset, follow the steps given below. Click Custom Query on any dataset creation page. The Add Custom Query page is displayed. Enter a suitable Name for your custom query. Enter a suitable Description for your ...

    • Google Big Query

      Google Big Query is a serverless architecture. It lets you query huge amounts of data and provides desired results in seconds. It helps you to manage and analyse your data with built-in features. Prerequisites for a Google Big Query are: Google Cloud ...

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