topic Check the RLS for roles already set up in Report Server

Check the RLS for roles already set up

yakovlol — Wed, 14 Aug 2024 15:47:07 GMT

Hello!

I have an issue and am not sure how to check this.

So I have a lot ( 50+) roles assigned to different people. All this roles were set up manually this is the legacy report.

But I need to figure out what this particular role sees ( I mean what users these roles see).

Maybe there is any chance of checking it automatically somehow.

For now only way to check is to manualy click on each role - and see what this role show.

Want to find a way to automatically check what exactly each role show.

Thank you.

Re: Check the RLS for roles already set up

Greg_Deckler — Wed, 14 Aug 2024 17:47:09 GMT

yakovlol I don't know of anything that will automate that.

Re: Check the RLS for roles already set up

yakovlol — Thu, 15 Aug 2024 07:40:18 GMT

Hello Greg_Deckler . Thanks for your reply. I have no idea neither how to automate that, only manually varification

Re: Check the RLS for roles already set up

Anonymous — Fri, 16 Aug 2024 03:20:55 GMT

Your ideas is great Greg_Deckler

Hi, yakovlol

As Super user said, you need to manually check your role in Power BI Report.

As described in another case:

Solved: RLS with user part of Multiple Roles - Microsoft Fabric Community

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Check the RLS for roles already set up

yakovlol — Tue, 20 Aug 2024 09:17:38 GMT

Thank you, Anonymous

Re: Check the RLS for roles already set up

Anonymous — Thu, 22 Aug 2024 08:34:29 GMT

Hi, yakovlol

Thank you very much for your reply. If I have already answered your question, you can mark the response to your question as a solution. When other members of the community encounter similar doubts, they can quickly find relevant responses, so as to save the time of corresponding community members to find answers.

Your cooperation will work with us to promote the development of the community. Thank you again for your cooperation.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.