refresh empty extract with row level security

tableaucommunity@tableau.com — Tue, 20 May 2014 21:40:30 GMT

Hello,

Due to an extract that is somewhat large, I want to publish it empty then refresh on the server.

This extract also needs to use row-level security - internal employees can see all data but sales reps can only see their own data.

To implement the empty extract, I used this method:

http://www.tableausoftware.com/about/blog/2013/9/easy-empty-local-extracts-25152

This works as expected

To implement the row-level security, I used this method:

http://kb.tableausoftware.com/articles/knowledgebase/securing-user-filters-for-web-editing-data-server

To allow internal employees to see all data, I modified the calculated field to the following:

username() = [AD_Name_Short] OR ismemberof("Internal Employees")

Here is the problem:

Now when I publish the empty extract and run a refresh on the server, the extract stays empty. I assume(?) it is because the row-level security clause is evaluating to false for every row as the user is the execution account and not a member of "Internal Employees".

Is there a way to make both of these work together? Did I miss something obvious?

Content in Tableau Community Forums

refresh empty extract with row level security