KNOWLEDGE BASE

Incorrect Data Displayed on Initial Load of View Containing Row Level Security Filters


Published: 14 Feb 2019
Last Modified Date: 05 Aug 2020

Issue

When initially loading a workbook that contains user filters built using user functions such as USERNAME() or ISMEMBEROF(), the view does not filter by these functions on initial load. 

 

Environment

 
  • Tableau Server 2019.1
  • Tableau Mobile
  • Row Level Security 
  • Published Data Sources

Resolution

Option 1

Upgrade to Tableau Server 2019.1.1 (download page)

Option 2

Run the following commands to disable the LogicalQueryCache

tsm stop
tsm maintenance cleanup -r
tsm configuration set -k features.LogicalQueryCache -v false
tsm pending-changes apply
tsm start

Notice For Tableau Mobile

Additional mitigation steps may be required for Tableau Server environments that use Tableau Mobile. Please see the [Important] ADV-2019-003 Partial Information Disclosure With User Filters security disclosure for full details and mitigation steps. 

Cause

This behavior is related to a known issue with ID 876160, which has been resolved in Tableau Server 2109.1.1.

Additional Information

  • This issue only occurs with published data sources. 
  • Clicking "Refresh" will correctly load the filtered view.



Discuss this article... Feedback Forum
Did this article resolve the issue?