RLS in BI Desktop (without BI Service!)

[Catcheson]

Morning

i am developing reports in Power BI Desktop and making them available to users in Report Server so not using BI Service at all.

i have created roles in Desktop to allow me to apply RLS but cannot add users to these roles as I am not using BI Service.

Can I somehow make use of the RLS without BI Service?  Can I add users to roles in Report Server?

not sure if I’m even asking the right question so all help much appreciated...

[v-piga-msft · Accepted solution]

Hi @Catcheson,

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. 

You could vote this idea here and add your comments to improve Power BI and make this feature come soon.

In addition, 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".

Reference:

https://community.powerbi.com/t5/Developer/How-to-Implement-Row-Level-Security-in-on-premises-SSRS-h...

http://community.powerbi.com/t5/Report-Server/Row-Level-Security-in-Power-BI-Report-Server/td-p/3115...

Best Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @Catcheson,

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. 

You could vote this idea here and add your comments to improve Power BI and make this feature come soon.

In addition, 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".

Reference:

https://community.powerbi.com/t5/Developer/How-to-Implement-Row-Level-Security-in-on-premises-SSRS-h...

http://community.powerbi.com/t5/Report-Server/Row-Level-Security-in-Power-BI-Report-Server/td-p/3115...

Best Regards,

Cherry

[Catcheson · Accepted solution]

Thank you for taking the time to get back to me.  That’s really well clarified.

thanks

claire