Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
Is it possible to apply RLS on Power BI report server?
If Yes, request you to explian the steps.
Regards,
Ameya
Hi @Anonymous,
Currently, RLS only works when publishing Power BI reports to service, as we need to add members to roles on service site. Power BI Report Server doesn't support this feature.
However, if your data source supports RLS, you can configure RLS on data source side. After publishing report to Power BI report server, set the data source credential to "As the user viewing the report". Here is a similar thread for your reference.
Best regards,
Yuliana Gu
May I suggest you mention this on the RLS documentation? PBI RS is nowhere to be seen there:
https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/
And the PBI RS version of PBI Desktop does have the Security > Manage / View Roles buttons, which do work (I just tested it in PBI RS Desktop August Preview). Does this mean RLS will be supported in the Q4 GA release? It's a bit cumbersome to have to manage RLS in the SQL source (and at least we have that option, it's not the case for all data sources).
same question
User | Count |
---|---|
9 | |
8 | |
5 | |
3 | |
1 |
User | Count |
---|---|
17 | |
12 | |
3 | |
2 | |
2 |