How do I check permissions within a report

[Anonymous]

In legacy SSRS, we have AD groups with access to particular folders. This provides access to a particular set of reports by business unit. In our environment, HR reports don't need to be viewed by IT Service Desk, and so forth. We have recently begun rolling out stock reports in SSRS that looks at access permissions for a particular user ID and then will only allow them to look at particular information in the stock report.

I am struggling to find the best way to do a similar kind of segmentation in PowerBI. Is there a way to use the existing stored procedure we are using for SSRS to pull up the "allowed" dataset in a PowerBI Desktop report?

Ideally, it would be awesome if I could have a landing report that would auto-redirect to the allowed reports. I may be trying to reinvent the wheel here, and so if I'm barking up the wrong tree, as it were, I'm open to alternatives.

Thank you!

[Anonymous]

Thank you for this! It took me a bit to get this project done around other tasks, but RLS seems to be working perfectly.

[lbendlin · Accepted solution]

Sort of.  Standard practice is to maintain a central mapping table (for example in SQL Server) that your developers can then consume and apply to their RLS rules.