Forum Discussion

Deepesh_V95's avatar
Deepesh_V95
Frequent Visitor
4 years ago
Solved

How to test RLS when Power BI is connected live to Analysis Services?

Hi,   I have recently moved our clients Power BI Reports to Azure Analysis Services with Live connection. Only problem and this is a major issue for customer here is that now "View As" option for t...
Need Help
Tips and Tricks
  • TomMartens's avatar
    TomMartens
    4 years ago

    No,

    create a "testuser"


    1. assign this user to a role

    2. login as "testuser" using a different tool then SSMS

    3. take screenshots that are documenting your test results and log out

     

    repeat with step 1 and another role

     

    Regards,

    Tom

Deepesh_V95's avatar
Deepesh_V95
Frequent Visitor
4 years ago

Hi,

 

In my scenario, RLS is implemented and that configuration is done through Visual Studio. What I'm looking for is an easy way to test this RLS like we do in Power BI.

I cannot test this RLS in Power BI as it is live connected to Analysis Services. So, please suggest what will be ideal way here to test this out apart from SSMS if possible?
lbendlin TomMartens