Dataset access is not coming while opening the chart.

[Nagarajkalasagonda]

I have created on role with few of the role permission. referring that i am able to apply rls . But while opening the chart in designer mode i getting error:

even the url is not generating full:
Role i Testing url is :
{url}/explore/?viz_type=big_number_total&datasource=77__table

for admin:
{url}/explore/?form_data_key=X5dLX9ezsyc&viz_type=big_number_total&datasource=77__table&datasource_id=77&datasource_type=table

Where as for that table i have given the access:

please confirm what exact permission i am missing

[dosubot[bot]]

The most common reason for this issue is that the custom role is missing one or more critical permissions required for chart exploration and dataset access. Besides dataset access and RLS, your role needs:

• can_read and/or can_explore on the dataset and its database,
• datasource_access on the dataset (or schema/database),
• and possibly can_explore or can_read on the Chart view if you want to use designer mode.

If any of these are missing, Superset can't generate the full explore URL or load the chart, resulting in errors about missing dataset_id or slice_id parameters. The admin role works because it has all these permissions by default.

To resolve this, compare your custom role's permissions with the admin role and ensure it includes all the above for the relevant dataset and database. You can do this in the Security > List Roles section of Superset. More details on how these permissions are enforced can be found in the codebase (example, another).

If you still have trouble after updating permissions, check the Superset logs for any permission-denied errors—they often specify exactly which permission is missing.

To reply, just mention @dosu.

---

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