Drill down issue with Embedded Superset Dashboard in Angular App

[maitti-dev]

Problem Description

I’m having some issues with the Superset dashboard I embedded in my Angular project.
When I right-click on a chart to select the 'Drill to detail' option, it doesn’t show up. Instead, I see 'Drill by' and get these error messages: “Failed to load dimensions for drill by” and “This session has encountered an interruption, and some controls may not work as intended. If you are the developer of this app, please check that the guest token is being generated correctly.”

I’d like the 'Drill to detail' option to show up and for there to be no errors when loading dimensions for 'Drill by'.

The user I’m using has an Admin role.

Environment Setup

Angular Version: 18
Superset Version: 4.0.2
@superset-ui/embedded-sdk: 0.1.2

Screenshots

From Superset:

From Angular Application:

Embedding Code:

async embedDashboardSuperset(): Promise<void> {
    try {
      const res = await firstValueFrom(this.fetchGuestToken());
      embedDashboard({
        id: res['dashboardId'],
        supersetDomain: 'http://localhost:8088',
        mountPoint: document.getElementById('dashboard'),
        fetchGuestToken: () => res['token'],
        dashboardUiConfig: {
          hideTitle: false,
          hideChartControls: false,
          hideTab: false
        }
      });
    } catch (error) {
      console.error('Error embedding dashboard:', error);
      throw error;
    }
  }

Has anyone run into similar issues with embedding Superset in an Angular app? Am I missing any config? Any known workarounds for this?

Thanks for any help!

[dosubot[bot]]

Hey @maitti-dev, I'm here to assist you with any bugs, questions, or contributions you have. Let's solve this together!

I found some similar issues and discussions that might help you:

1. Open Issue: Drill By not Working on Embedded app when not logged in to Superset. This issue suggests ensuring that the user is authenticated and has the necessary permissions to access the dataset API, as the problem might be due to insufficient permissions or lack of authentication ^[1].

2. Closed Issue: Cannot use drill-by/drill-to in embedded mode without can explore on Superset permission. This was resolved by adding granular permissions for actions in the dashboard ^[2].

3. Closed Issue: DRILL_TO_DETAIL Feature is not working. The solution was to use version 2.1.0rc1 or update to the latest master branch, as the feature was merged after 2.0.0 ^[3].

To resolve your issue, consider the following steps:

• Permissions: Ensure that your user has the necessary permissions. For 'Drill to detail', you need can_samples on Datasource and can_explore on Superset or can_drill on Dashboard ^[4].

• Guest Token: Verify that the guest token is generated correctly. The backend must have the can_grant_guest_token permission to make the POST request for generating guest tokens ^[5].

• Chart Type Support: Ensure the chart type supports 'Drill by'. Some chart types may not support this feature ^[6].

• Error Handling: Check the implementation of loadOptions to ensure it correctly fetches dataset columns and handles errors properly ^[6].

By addressing these areas, you should be able to resolve the issues with 'Drill to detail' and 'Drill by' in your embedded Superset dashboard.

To continue talking to Dosu, mention @dosu.