Forum Discussion

DeanUW's avatar
DeanUW
Helper I
4 years ago
Solved

Static RLS not showing data in Power BI Service

I have implemented a static RLS based on office key on a dimension table of a star schema.  The RLS works perfectly in Power BI desktop when I "View as".  The RLS works perfectly fine when I "Test as...
Data Protection
Need Help
  • DeanUW's avatar
    DeanUW
    4 years ago

    Hi GilbertQ,

     

    That explination made total sense, thank you again.  I was able to resolve the issue by modifying the DAX using the double pipe ||.  Allowing me to add the additional office locations to a single RLS role, then assigning the appropriate people to that single RLS role.

     

    Example:  [Office Name] = "XXXX" || [Office Name] = "YYYY"

     

    Hope this may help others!  Thank you again!