{"id":8741,"date":"2025-03-29T10:25:53","date_gmt":"2025-03-29T04:55:53","guid":{"rendered":"https:\/\/pheonixsolutions.com\/blog\/?p=8741"},"modified":"2026-09-01T12:43:12","modified_gmt":"2026-09-01T07:13:12","slug":"apache-superset-managing-filter-options-and-edit-chart-permission","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/apache-superset-managing-filter-options-and-edit-chart-permission\/","title":{"rendered":"Apache Superset: Managing Filter Options and Edit Chart Permission"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">Introduction<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Apache Superset provides powerful filtering options to enhance data visualization and user experience. This document explains how to use native filters and prefilters in dashboards, how to integrate filtered dashboards into web applications, and how to manage permissions to restrict users from editing charts.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Prerequisites<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Apache Superset installed and configured.<\/li>\n\n\n\n<li>Administrator credentials for Apache Superset.<\/li>\n\n\n\n<li>A dashboard with filters configured.<\/li>\n\n\n\n<li>A web application if the dashboard needs to be embedded.<\/li>\n\n\n\n<li>Access to Superset role and permission settings.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Implementation<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">Filter Options in Apache Superset<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Apache Superset provides two primary methods to filter data in dashboards:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. Prefilter<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Prefiltering allows predefined filtering on the dashboard before the user interacts with it.<\/li>\n\n\n\n<li>Useful for restricting data visibility based on user roles or predefined criteria.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">2. Native Filter<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Native filters provide an interactive filtering experience for users directly in the dashboard.<\/li>\n\n\n\n<li>They allow dynamic data filtering based on selected criteria.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">A sample <strong>Filter-ID<\/strong> and <strong>Token<\/strong> are provided below:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Filter ID:<\/strong> <code>NATIVE_FILTER-xxxxxxxxxxxxxx1<\/code><\/li>\n\n\n\n<li><strong>Token:<\/strong> <code>43Tbxxxxxx890RT<\/code><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Using these, you can filter data in a dashboard URL as follows:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">https:\/\/localhost:5000\/superset\/dashboard\/b669334e-7948-4fb5-80eb-6f4eac6d86bc\/?permalink_key=pAzJAb0Mg3K&amp;standalone=1&amp;native_filters=(${filterId}:((__cache:(label:'${token}',validateStatus:!f,value:!('${token}')),extraFormData:(filters:!((col:token,op:IN,val:!('${token}'))),apply:!t),filterState:(label:'${token}',validateStatus:!f,value:!('${token}')),id:${filterId},ownState:()))&amp;random=${Math.random()}<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This URL can be used to pass the selected filter value to the dashboard.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Embedding Apache Superset Dashboards in Web Applications<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To integrate an Apache Superset dashboard into a web application, use an <strong>iframe<\/strong> as follows:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">https:\/\/localhost:5000\/superset\/dashboard\/b669334e-7948-4fb5-80eb-6f4eac6d86bc\/?standalone=1<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This will display the dashboard within your application. However, users may see an <strong>Edit Chart<\/strong> option when clicking the three dots on a chart. This allows direct access to Apache Superset without requiring login credentials.<\/p>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXf6vjrWQfW1bUAGJZA0BfSrrF0wrl9XvzRbL5wtwvPXG68pYjP5v52ePAWthbDmJ0a-u7limZNVgyGefcWUj_xJq6sp5DjyzCu3AqSm1YqsUGkJhMtwIXCNjXle56uJuyxx3CvcRQ?key=WMvh7dVSaL4KV4riMQholPp-\" alt=\"\" style=\"width:238px;height:auto\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">To restrict this permission, follow the steps below:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Restricting the \u201cEdit Chart\u201d Permission<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Log in to Apache Superset<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Log in using your administrator credentials.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Navigate to Role Management<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on <strong>Settings<\/strong> \u2192 <strong>List Roles<\/strong>.<\/li>\n\n\n\n<li>Locate the <strong>public<\/strong> role (or the role assigned to embedded dashboard users).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Modify Permissions<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click <strong>Edit<\/strong> on the <strong>Public<\/strong> role.<\/li>\n\n\n\n<li>Look for the permission &#8220;<strong>Can explore on Superset<\/strong>&#8220;.<\/li>\n\n\n\n<li><strong>Remove this permission<\/strong> and save the role.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfzld3VQhTAgFM8G2phN0anf-I2hTpHakHGi6ZXIjsSmIiUZZFrysQARENASY-ELMzeBus02sZb2-oLXAOao6qZjxPzaCOdPxfZUxExJEG-Oyg_946-xOcCPyu87tnt2hETjKaU?key=WMvh7dVSaL4KV4riMQholPp-\" alt=\"\" style=\"width:588px;height:auto\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 4: Validate Changes<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open your embedded dashboard again.<\/li>\n\n\n\n<li>The <strong>Edit Chart<\/strong> option should now be removed.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image is-resized\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXewTSwgnhXhkSis2wsw60v_iKsfJ0pZKgr4RX-Ls7pikNddSxyMkrn0rMunZZN2LxSvyZv02m1cyiXdkCB6MkUNR6kTJjvL-QS-b_xs2AMNLvQCJZRuFPujhRI6I73Ll-1g9Y5RUw?key=WMvh7dVSaL4KV4riMQholPp-\" alt=\"\" style=\"width:236px;height:auto\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Apache Superset provides flexible options for filtering dashboard data and embedding dashboards into web applications. Prefilters and native filters can be used to control and dynamically filter dashboard data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When dashboards are embedded into external applications, managing user permissions is also important. Removing the <strong>Can explore on Superset<\/strong> permission from the appropriate role can restrict users from accessing the chart editing functionality.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">FAQs<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. What are native filters in Apache Superset?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Native filters provide an interactive way for users to filter dashboard data based on selected criteria.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. What is the purpose of prefiltering?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Prefiltering allows predefined filters to be applied to a dashboard before users interact with it. It can be useful for restricting data based on predefined conditions.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3. Why does the Edit Chart option appear in an embedded dashboard?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The <strong>Edit Chart<\/strong> option can appear when the user or role has the required Superset permissions, such as <strong>Can explore on Superset<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4. How can I remove the Edit Chart option?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Log in as an administrator, navigate to <strong>Settings \u2192 List Roles<\/strong>, edit the relevant role, remove <strong>Can explore on Superset<\/strong>, and save the changes.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">5. Can an Apache Superset dashboard be embedded into another website?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Yes. A Superset dashboard can be displayed inside a web application using an iframe or other supported embedding methods.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Related Articles<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Install Apache Superset on Ubuntu via Docker Compose<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Learn how to install and configure Apache Superset on Ubuntu using Docker Compose.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a target=\"_blank\" rel=\"noreferrer noopener\" href=\"https:\/\/pheonixsolutions.com\/blog\/how-to-install-apache-superset-on-ubuntu-via-docker-compose\/?utm_source=chatgpt.com\">How to Install Apache Superset on Ubuntu via Docker Compose<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Embed Superset Dashboard with Authentication and RLS<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Learn how to embed an Apache Superset dashboard into a private website while implementing authentication and Row-Level Security (RLS).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a target=\"_blank\" rel=\"noreferrer noopener\" href=\"https:\/\/pheonixsolutions.com\/blog\/embedding-superset-dashboard-into-a-private-website-with-authentication-and-row-level-security-rls\/?utm_source=chatgpt.com\">Embedding Superset Dashboard into a Private Website with Authentication and RLS<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Talk to our experts<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Looking for the right technology solution for your business? Our team of experts can help you with development, cloud, DevOps, design, and a wide range of other technology needs. Get in touch with our team&nbsp;<a href=\"https:\/\/pheonixsolutions.com\/contact\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Apache Superset provides powerful filtering options to enhance data visualization and user experience. This document explains how to use [&hellip;]<\/p>\n","protected":false},"author":507,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1022,1044],"tags":[],"class_list":["post-8741","post","type-post","status-publish","format-standard","hentry","category-web-architecture","category-apache","psol-cat-web-architecture"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/phn2x7-2gZ","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/8741","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/users\/507"}],"replies":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=8741"}],"version-history":[{"count":2,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/8741\/revisions"}],"predecessor-version":[{"id":11267,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/8741\/revisions\/11267"}],"wp:attachment":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=8741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=8741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=8741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}