In Superset’s native UI, the Drill By option appears for charts, but when the same dashboard is embedded into a React application using the Superset Embedded SDK, the Drill By option is missing, even though hasDrillBy is set to true in dashboardUiConfig.

[prsandeep]

import React, { useEffect, useRef, useState } from 'react';
import { useNavigate } from 'react-router-dom';
import { embedDashboard } from '@superset-ui/embedded-sdk';
import { bugzillaApi } from '../services/bugzillaApi'; // Import the separate API service
import '../bugzilla.css';

function BugzillaDashboard() {
const navigate = useNavigate();
const dashboardId = 'e191eb89-281d-4d10-8bcd-2dc415b9514e';
const containerRef = useRef(null);
const [loading, setLoading] = useState(true);
const [error, setError] = useState(null);
const [dashboardConfig, setDashboardConfig] = useState(null);

const handleGoBack = () => {
navigate(-1); // Go back to previous page
};

useEffect(() => {
const embedSupersetDashboard = async () => {
try {
setLoading(true);
setError(null);

    // Get guest token using the separate API service
    const tokenResponse = await bugzillaApi.getGuestToken(dashboardId);
    const guestToken = tokenResponse.data.token;

    if (!guestToken) {
      throw new Error('Guest token missing in response');
    }

    // // Optionally, get dashboard configuration
    // try {
    //   const configResponse = await bugzillaApi.getDashboardConfig(dashboardId);
    //   setDashboardConfig(configResponse.data);
    // } catch (configError) {
    //   console.warn('Could not fetch dashboard config:', configError);
    //   // Continue without config - not critical
    // }

    // Embed the dashboard
    await embedDashboard({
      id: dashboardId,
      supersetDomain: 'https://bidarshan-dev.dcservices.in/',
      mountPoint: containerRef.current,
      fetchGuestToken: () => guestToken,
      dashboardUiConfig: {
        hideTitle: true,
        hideChartControls: false,
        hideTab: false,
        hasDrillBy: true,
        // You can use dashboardConfig here if needed
        ...(dashboardConfig?.uiConfig || {})
      },
    });

    setLoading(false);
  } catch (err) {
    console.error('Error embedding Superset dashboard:', err);
    
    // Handle different types of errors
    const errorMessage = err.userMessage || err.message || 'Failed to load dashboard';
    setError(errorMessage);
    setLoading(false);
  }
};

embedSupersetDashboard();

}, [dashboardId]);

return (

{/* Back Button */}
<div style={{
position: 'absolute',
top: 10,
left: 10,
zIndex: 1000
}}>
<button
onClick={handleGoBack}
style={{
padding: '8px 15px',
background: '#6c757d',
color: 'white',
border: 'none',
borderRadius: '4px',
cursor: 'pointer',
fontSize: '14px',
display: 'flex',
alignItems: 'center',
gap: '5px'
}}
>
← Back

  {loading && (
    <div style={{ 
      position: 'absolute', 
      top: 10, 
      left: 120, 
      zIndex: 1000,
      background: 'rgba(255, 255, 255, 0.9)',
      padding: '10px',
      borderRadius: '4px'
    }}>
      <p style={{ color: '#555', margin: 0 }}>Loading dashboard...</p>
    </div>
  )}
  
  {error && (
    <div style={{ 
      position: 'absolute', 
      top: 10, 
      left: 120, 
      zIndex: 1000,
      background: 'rgba(255, 0, 0, 0.1)',
      padding: '10px',
      borderRadius: '4px',
      border: '1px solid #ff0000'
    }}>
      <p style={{ color: 'red', margin: 0 }}>Error: {error}</p>
    </div>
  )}


  <div id="dashboard-container" ref={containerRef} />
</div>

);
}

export default BugzillaDashboard;

[dosubot[bot]]

Hi @prsandeep! I'm Dosu and I’m helping the superset team.

The Drill By feature is now officially supported in embedded dashboards as of Superset 4.1.1+ (PR #34319). However, its visibility in embedded mode does not depend on the dashboardUiConfig.hasDrillBy flag alone. Instead, the guest token's role must have the required permissions: specifically, can_drill (on Dashboard), can_write (on ExploreFormDataRestApi), and can_samples (on Datasource). If these permissions are missing, Drill By will not appear, even if it does in the native UI.

Make sure your Superset backend is version 4.1.1 or later, and that the guest/embedded role used for the token has all the necessary permissions. Also, note that Drill By only appears for supported chart types and when the chart data structure allows it (i.e., grouped by dimension value) reference.

If you’ve confirmed the above and still don’t see Drill By, check for version mismatches between your Embedded SDK and Superset backend, and ensure your chart type supports Drill By.

Let me know if you need details on how to set these permissions.

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}    

[prsandeep]

Hi @dosu, thanks for the clarification.

I’m using Superset v4.1.2 with @superset-ui/embedded-sdk v0.2.0. I’m embedding the dashboard in a React app using Admin credentials to generate the guest token, but the token’s "roles" is currently set to ["Guest"]. I’ll make sure this role has the required permissions (can_drill on Dashboard, can_write on ExploreFormDataRestApi, and can_samples on Datasource).

I’ll verify that the charts I’m testing with are supported for Drill By and that there are no version mismatches between the SDK and backend. If I still face issues after setting the permissions, I’ll share the details with you.

Thanks for the guidance!

[dosubot[bot]]

Your plan sounds solid. For Drill By to work in embedded dashboards, the guest token’s role (like "Guest") must have at least these permissions: can_drill on Dashboard, can_write on ExploreFormDataRestApi, and can_samples on Datasource. You can update these in Superset’s Security → List Roles UI: edit your guest role, add the permissions, and save. After making changes, it’s best to sync roles and restart Superset to ensure everything applies correctly.

If you want to test quickly, you can temporarily set GUEST_ROLE_NAME to "Admin" in your superset_config.py, confirm Drill By appears, then revert to a more restrictive role with only the needed permissions (details). No need to manually assign users to the guest role—the guest token mechanism handles that automatically (details).

Let me know if you hit any issues after updating permissions or if you want a step-by-step walkthrough for the UI!

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}    

[prsandeep]

I checked the embedded dashboard, and I’m see Drill to detail and Drill to detail by, but I still don’t see the Drill By option.

[prsandeep]

@dosu (https://go.dosu.dev/dosubot)

but after embed

[prsandeep]

Hi @dosu, thanks for the clarification.

I’m using Superset v4.1.2 with @superset-ui/embedded-sdk v0.2.0. I’m embedding the dashboard in a React app using Admin credentials to generate the guest token, but the token’s "roles" is currently set to ["Admin"]. I’ll make sure this role has the required permissions (can_drill on Dashboard, can_write on ExploreFormDataRestApi, and can_samples on Datasource).

I’ll verify that the charts I’m testing with are supported for Drill By and that there are no version mismatches between the SDK and backend. If I still face issues after setting the permissions, I’ll share the details with you.

Thanks for the guidance!