RLS Not Working for a Single Group

[tficar]

I have a report set up with RLS that was working perfectly fine until today. The report restricts access based on the brand that the user is associated with. Again, this was working perfectly and as expected. I did update the data today, but it was only a minor appending of a few days worth of data. Nothing that should affect this, but that's obviously still a possibility.

The annoying part with all of this is that the error is only for a single group (yellow highlight in snippet below). In addition to this, the report in Desktop works as expected. It is only in the Online Service that the issue occurs. Any ideas? I have already checked the underlying data to make sure that the Group restriction did not change when I updated the data. Everything looks correct (which explains why Desktop is working).

Been stuck at this for multiple days now so any help is greatly appreciated!

[tficar · Accepted solution]

I figured out a workaround:

1. Delete the report
2. Re-publish the report
3. Re-assign users to groups

Not ideal but it works!

[GilbertQ]

Hi @tficar 

Can you check to see if this group of users was added to the App Workspace roles, which would allow the users to see all the data?

[tficar]

Thanks for replying @GilbertQ . I should have clarified more but the issue is that the user has no access to any brands, so their charts are blank. See below for a screenshot of what it looks like. You'll notice that Vitaburst is "selected" but it's just the previous value that was chosen before changing to the current user.