Are you saying that the Data source is unfiltered, and that the row level filtering is being done in the workbook that the end user is able to access via Web Edit?
If so, then there is nothing stopping the end user from removing the filter in web edit and accessing all of the data.
Tha's correct the data source published is unfiltered but filtered in the workbook.
What if the data source is filtered and embedded in the workbook?
I tested it in some of the tableau samples that come with tableau server (they are embedded data sources in workbook) and it doesn't show the data source to select when hitting +datasource button. However, I don't know if embbeding it allows for the data to refresh?
I assume embedding the filtered data source in the workbook could be an option?
If the data source is unfiltered and the filtering is being done in the workbook, then by using web edit, the end user will be able to remove those filters and have access to all of the data.
If you add the filter to the data source (as a data source filter) and then publish the data source to the server, the end user will only be able to see data relevant to them ( either through connected workbooks, or when connecting to the Data Source directly)
Also, the end user will not be able to remove those filters either
See link below on how to add a data source filter
All the best
Thanks Glen this has helped a bunch. We're currently only putting the filter you have from the link above in the workbook but not in the actual data source that is published. If we go the route of filtering the data source and publishing that filtered data source, along with the workbook filtered, would that mean we would have several different data sources, on the server, for each of the workbooks that we produce?
Workbook 1 = Data Source Filtered on ID 1
Workbook 2 = Data Source Filtered on ID 2
So we would have multiple extracts of the data on the server? Also, would need to schedule extracts for each of those data sources as well?
If you use published data sources, then you are sharing the data source between different workbooks that connect to it.
So you can have one data source being used by multiple workbooks.
The filter that you apply on the data source is also used by the workbook to limit data shown, so there is no need to add additional row level filters into the workbook
Additionally, with the published data source, you can assign an extract refresh schedule to it, which will update the data.
Hope this clears this up for you