Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
13 | |
9 | |
7 | |
2 | |
2 |