Issues in Implementing Dynamic Row level Security

[jag1912]

Hi 

I am trying to implement dynamic row level security for my PBI report. We have table which is having two columns useremail and teampath.  I want to filter data on the report based on the user logged and giving access to  the teampaths to which this user is assigned. My model has 3 facts  which are interlinked. Relationship flow is set bi directional where ever required. When I testing it, all the visuals on report are not refreshing as per dynamic access. Only the visuals which are dependent on fact which is linked to teampath holding dimension are refreshing. But when I am going on the Teampath slicer manually on the report and selecting all the teampath with shift key multi select, its working fine. Below is the DAX formula implemented.

[Teampath] = LOOKUPVALUE(UserPermissions[Teampath],UserPermissions[userEmail],USERPRINCIPALNAME(),UserPermissions[Teampath],dim_codeinsightProject[Teampath]) && NOT(ISBLANK(dim_codeinsightProject[Team-path]))

It seems that select all on the top is causing this issue.

Because when I am manually selecting these teampaths with shift key except select all , its working fine.

Thanks for the suggestions.

[jag1912]

This issue is now resolved. I played with all the relationships and applied security filters in both directions on couple joins. Then it started refreshing all the visuals. The nature of this data is very confidential thats why I couldn't post many details here.

[v-yanjiang-msft]

Hi @jag1912 ,

It's hard to reproduce your problem, could you please provide a sample file or more details?

Best Regards,
Community Support Team _ kalyj