Forum Discussion

abhiram342's avatar
abhiram342
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

RLS DAX Query Optimization

Hi Team,   I have implemented RLS on below model but the performance is slow. can some please suggest way to optimize DAX Code. RLS Tables: User Product Sub: A User can have access to atleast one...
"Need Help"
@Dax help
Dynamic RLS
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Why are customers linked to products?  These should be independent dimension and the product ID should be listed in the Sales table.

  • abhiram342's avatar
    abhiram342
    Icon for Microsoft Employee rankMicrosoft Employee
    3 years ago

    Hi lbendlin - Thank you for your response. Adding ProductID to Fact requires us to reprocess all the fact data and it takes 2-3 days to reprocess historical data. As per existing design, we have relationship between Product and Customer Table. Product Table is small  (130 rows) and Customer is large ( 9 Million rows). 

     

    Please suggest if there is way that i could optimize  DAX query in RLS 

     

    Thanks,

    Abhiram

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago

      Do the normalization in Power Query, or challenge the need for RLS in this scenario.