RLS filter settings are invisible after creation but are still being applied (Datamart)

[jonmaas]

Hello everyone,
I am seriously scratching my head right now trying to figure out if I am making mistakes or if I am encountering a bug.
After creating a datamart I wanted to implement the most basic RLS there is: Show only rows where the value of a column is "X" and give this role to a single e-mail adress. Creating the roles, their filters and adding an e-mail worked fine. The issue arises when I try to modify those rules (e.g. only show rows with column value "Y" instead of "X"). I am unable to even see those rules I just created. The most frustrating thing about it however, is that it shows me that there are some filters being applied, but not which:

The filter symbol is visible and when I click on the 3 dots I can also select "Copy table filter from" (there is a second role). When I try to view a report that has these (invisble) filters applied to it with an account which has the role I can see that the filters are being applied correctly.
To summarize: I created very simple RLS, saved it, refreshed the datamart and now I can no longer change it. Previously made filter rules are invisible and when I try to add new rules the save button is either greyed out or unresponsive (while being green). Emptying the chache has already been attempted and solved nothing.
Am I comitting some major (or stupid) errors or are datamarts just that buggy? I couldn't find any other mentions of this problem, which would refute the second option...

Thanks in advance for any advice, I am rapidly losing my mind here.

[GilbertQ]

Hi @jonmaas 

I am not sure if it is possible to modify the existing roles on a datamrt. What I will suggest doing is to delete the RLS roles and recreate them and see if that solves your issue?

[jonmaas]

Thank you Gilbert,
sadly this is something I tried multiple times already yesterday. The Roles forget their assigned e-mails but otherwise stay intact after deletion. I have also tried refreshing the datamart but this did not make the roles disappear either. My hours of googling yesterday suggests that it might be something interacting with the dataflow that is blocking it from updating it's roles. Pretty sure that's not the case as I am the only user with access to the datamart. Also, while I am here:

How comes that the semantic models created by the datamart always stay stuck on their creation date in terms of their last refresh date shown?

Any further help you could provide would be great!

[GilbertQ · Accepted solution]

Hi @jonmaas 

I would suggest logging a support ticket for this. I'm not sure how else to resolve this?