Drill to Detail in Embedded dashboard is not availab even it is set to TRUE in config fil

[shujamughal]

Hey Community,

I am having trouble enabling the drill-to-detail option in the embedded table. It is available when the table is opened in the superset, but when I embed the same table in the application, this option is not present.
I did some research and found that the DRILL_TO_DETAIL property needs to be set to TRUE in the config file. I have done this; however, the drill-to-detail option did not become available in the superset embedded table.

Could you let me know how I can solve this?

Any help would be highly appreciated.

Thanks
Shuja

[dosubot[bot]]

To address the issue of the "Drill to Detail" feature not appearing in embedded dashboards, even after setting the DRILL_TO_DETAIL property to TRUE, consider the following:

1. Feature Flag Configuration: Ensure that the DRILL_BY feature flag is set to TRUE in the Superset configuration file, as DRILL_TO_DETAIL is deprecated. The correct configuration should look like this:

   FEATURE_FLAGS = {
       "DRILL_BY": True,
   }

2. Permissions: Verify that the user has the necessary permissions to access the drill-to-detail feature in embedded dashboards. The required permissions are:

   • can_explore on Superset or can_drill on Dashboard
   • can_samples on Datasource ^[1].

3. Limitations and Restrictions: Be aware of specific limitations or restrictions that might affect the availability of the drill-to-detail feature:

   • The feature is disabled if the database settings explicitly disable it.
   • It is disabled if the chart does not group data by dimension value (i.e., lacks aggregations).
   • It is not supported for certain chart types that do not handle the contextmenu event for dimensions ^[2][3].

By ensuring these configurations and permissions are correctly set, the drill-to-detail feature should become available in your embedded dashboards.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}