<p dir="auto">Make sure these boxes are checked before submitting your issue - thank you!</p>
<ul dir="auto">
<li>[yes] I have checked the superset logs for python stacktraces and included it here as text if any</li>
<li>[yes] I have reproduced the issue with at least the latest released version of superset</li>
<li>[yes] I have checked the issue tracker for the same issue and I haven't found one similar</li>
</ul>
<h3 dir="auto">Superset version</h3>
<p dir="auto">Superset 0.20.4</p>
<h3 dir="auto">Expected results</h3>
<p dir="auto">Only one dashboard with multiple data source which can change for specific users.</p>
<p dir="auto">Imagine you've connected a data source to Superset, containing data on all your clients and their corresponding account managers. To help the account managers perform their jobs better, you decide to build a beautiful dashboard containing all the right charts and visuals. However, these account managers shouldn't be able to see each other's client data (sensitive, security, etc.)</p>
<p dir="auto">If you only have a handful of account managers (AMs), it's easy to write a script to split the master data set into account manager-specific subsets before importing it to Superset, and then create tables from there. Problem solved.</p>
<p dir="auto">What if you have hundreds of AMs? One way to go about this is create a single dashboard with slices associated to the master data set, add a filter box, select the AM you want to narrow the data down to, and then export the report as a static image. This has several drawbacks:</p>
<ol dir="auto">
<li>The dashboard the AM receives is a static image.</li>
<li>Someone has to do apply the filter and perform the export manually each time.</li>
<li>AMs have to wait for someone to send them the report each time they want it.</li>
</ol>
<p dir="auto">Now, if it were possible to adapt the existing filter box to auto-detect the Superset user and auto-apply a preset filter, then disable the dropdown menu from being changed, you could do away with those 3 drawbacks.</p>
<p dir="auto">Of course there are millions of other ways to go about this, but thought I'd throw this out there.</p>