Forum Discussion

ajmonster's avatar
ajmonster
Helper II
5 years ago

Dynamic RLS Not Populating Visuals with Data

Hello   We have implemented Dynamic RLS with the use of Azure Groups (AG). We defined a few roles and assigned individual AGs to their proper role so that no AG is assigned to more than one role. ...
Need Help
ajmonster's avatar
ajmonster
Helper II
5 years ago

The DAX is: [Email] = USERPRINCIPALNAME(). When testing roles locally, the security works as intended.

 

The model is as follows:

'SalesOrg1Security' *->-* 'SalesOrg1Dimension' 1->-* 'Facts'

'SalesOrg2Security' *->-* 'SalesOrg2Dimension' 1->-* 'Facts'

Anonymous's avatar
Anonymous
Not applicable
5 years ago

hi ajmonster - Could you help understand why you have 2 security tables setup?

Just wanted to understand From a maintenance prospective it would be easier to maintain 1 security table. 

Could you share a screenshot of what the User sees while accessing the report? 

Happy to help!  

  • ajmonster's avatar
    ajmonster
    Helper II
    5 years ago

    We use two security tables because they are filtering on two separate columns within the 'Facts' table. I cannot share a screenshot due to sensitivty of the data.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      hi ajmonster - Just to confirm you have tested the report using the view as using specific user's email which are having issues in the published report correct? 

      • ajmonster's avatar
        ajmonster
        Helper II
        5 years ago

        Correct. I have tested the report using the view as the specific user's email which reported the issues.