RLS in BI Desktop (without BI Service!)

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-hosting/m-p/188678

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

Best Regards,

Cherry

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

thanks

claire