We’re experiencing an issue with our December monthly dashboard reports and need your assistance.
Background: We have Row-Level Security (RLS) configured with the following structure:
usernameclient_name
org_user1 (empty)
org_user2 (empty)
client1 clientname1
client2 clientname2
Issue: Our partners received their December monthly dashboard reports via email as scheduled, but the files/PDFs contain no data. We suspect this may be related to the RLS configuration.
Key Details:
No configuration changes have been made since Novemeber(when reports worked correctly)
The RLS is manually refreshed each time
Some users (user1, user2) have empty client_name fields, which hasn’t been problematic previously Questions:
Could the empty client_name fields suddenly be causing this issue?
Are there any known changes to RLS behavior that might explain this?
Would appreciate your help troubleshooting this as soon as possible.
This is quite interesting since the RLS worked normally last month and then without any changes made, it stopped working. I know that there was a new Data Prep experience rolled out in November but I do not see any documentation that it changed any prior settings in place.
This may be quite minor but I know when running some tests on RLS scenarios, this affected mine from working. So initially when testing out, I had my username field named in the same way, all lowercase and the RLS was not working. When I switched the username field to ‘UserName’, it seemed to start working.
Would you be able to adjust your field name and then try again to see if that fixes the issue?
Thank you for your response @Brett . I apologize for any confusion—I used ‘username’ as a generic example in my original question without paying attention to the casing. The actual column name we’re using is UserName (with capital U and N). Please see the attached screenshot for reference."
Hi @Brett we already raised the ticket before I created this ticket, I just wanted to know if anybody might help us with any solution but thank you for replying.
Just checking back in since we haven’t heard from you in a bit. I wanted to see if the guidance shared earlier helped resolve your question, or if you found a solution in the meantime. Moreover, if you support ticket resulted in any findings, please feel free to help the community by sharing!
If you still have any additional questions related to your initial post, feel free to share them. Otherwise, any update you’re able to provide within the next 3 business days would be helpful for the community.
Since I haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.
