Forum Discussion

tod's avatar
tod
Frequent Visitor
5 years ago
Solved

Dynamic RLS - Works in Desktop but not in Service

I need help with implementing RLS. Sorry this is yet another RLS problem.   I created a test model in Desktop using 2 tables. First, called Security, contains 2 columns: UserID (to enter email) and...
Need Help
  • tod's avatar
    tod
    5 years ago

    It turns out that the "test as role" functionality in the service is buggy and inacurrate. I ended up taking a chance and releasing the reports to my community despite what "test as role" was showing as my last resort. And RLS worked, meaning the "test as role" view was wrong and misleading. Is there a way to submit a bug report? 

     

    Thanks again for your posts and guidance.

tod's avatar
tod
Frequent Visitor
5 years ago

For some reason this is the 3rd time I'm replying to this so hopefully third time is the charm.

Thanks Stephen for the response.

> Data source is manually created in Enter Data in PBI for testing and the role setup is verified in Power BI.

> You are right. I published the report in another premium workspace that I know the 4 test users have no affiliation with the workspace and it works.

> So I went back to the original premium workspace and reviewed all the access rights. After either removing or changing to View or Read only, 2 of the 4 users still does have the RLS working so I'm stumped. Is there a "checklist" or list of where are the places we should look to review access rights setup?

 

Thanks again for your help.