Forum Discussion
RLS Not Working for a Single Group
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!
I figured out a workaround:
- Delete the report
- Re-publish the report
- Re-assign users to groups
Not ideal but it works!
3 Replies
- tficarFrequent Visitor
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.
- tficarFrequent Visitor
I figured out a workaround:
- Delete the report
- Re-publish the report
- Re-assign users to groups
Not ideal but it works!