Users suddenly experiencing security checks

[DatDataNerd]

Starting yesterday I have been having users experiencing an error where this notification flashes on screen when they try to open reports. The notification goes away so fast that it's hard to read, and reports won't open. Adding and removing permissions, logging out and back in, clearing cache, or logging in with a different browser doesn't help. And the issue isn't present for every user in a parciular reporting group, it is seemingly random. The only way I have found to resolve the issue is generating a share link for the report. Even a link with the rules, "only for people with existing access" will resolve the issue, and after clicking the link the user can access the report normally.

The dataset having issues has RLS and refreshes hourly. And all of the users experiencing this issue have an unfiltered rule for the dataset. No idea why random users in that group are experiencing this bug while others can access it just fine though. Any direction would be greatly appreciated.

[v-yetao1-msft]

Hi @DatDataNerd 

(1)What is the rule for your RLS ?

(2)You said that “The dataset having issues has RLS and refreshes hourly” , what is the refresh for the dataset ? What is the datasource for the dataset ?

(3) How do you share reports with users ? Regarding this report, are there any users who can access it? If so, please compare the differences.

Best Regard

Community Support Team _ Ailsa Tao

[DatDataNerd]

The dataset in question refreshed from a SQL server query. We were just having issues with a security group that should have been filtered to 'all', but the issue has since spread to others. I've now seen the same issue crop up on a report for an unrelated dataset that has no RLS at all.

All of our reports are shared via security groups, not individual users. Within an individual security group there are some users that can and cannot access certain reports. There does not seem to be a good pattern to it.