Forum Discussion

jfer's avatar
jfer
Frequent Visitor
1 year ago
Solved

RLS not working consistently - Only when refreshing

Hello,   I have a problem in my workspace with a report, I'm using RLS in Power BI Service following this schema:     The "All" role has the following RLS dynamic condition defined in the ...
Need Help
  • Poojara_D12's avatar
    Poojara_D12
    1 year ago

    Hi jfer 

    The issue likely occurs due to a caching or authentication problem in the Power BI Service.

     

    • Ensure the RLS condition email = USERPRINCIPALNAME() is correct and consistently matches the email format in your data.
    • Verify users are logged in with the correct account and have the appropriate roles assigned.
    • Refreshing the semantic model clears the cache, temporarily fixing the issue. To avoid this, disable Query Caching in the dataset settings.
    • Ask users to log out and back in or clear cookies to ensure proper session handling.

    These steps should resolve or reduce the problem.

     

    Did I answer your question? Mark my post as a solution, this will help others!

    If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

    Kind Regards,
    Poojara
    Data Analyst | MSBI Developer | Power BI Consultant
    Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

Poojara_D12's avatar
Poojara_D12
Super User
1 year ago

Hi jfer 

The issue likely occurs due to a caching or authentication problem in the Power BI Service.

 

  • Ensure the RLS condition email = USERPRINCIPALNAME() is correct and consistently matches the email format in your data.
  • Verify users are logged in with the correct account and have the appropriate roles assigned.
  • Refreshing the semantic model clears the cache, temporarily fixing the issue. To avoid this, disable Query Caching in the dataset settings.
  • Ask users to log out and back in or clear cookies to ensure proper session handling.

These steps should resolve or reduce the problem.

 

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS