Help needed :-Implement row level security in paginated reports

[santosh531]

Hi,

I downloaded Power BI report builder and developing reports. i would like to know how can we implement RLS for reports build using Report builder from Power BI service. Data source is on-prem SQL Server.

[tahirpk]

You need to build a model in Power bi Desktop ,Implement RLS on that model ,then use the Power bi Desktop model for Report parameters ,you may create SQL data source and data sets but the parameter should be in Power BI model For RLS .

[TeigeGao]

Hi @santosh531 ,

To enable Row-level security (RLS) in Power BI Report Server, please refer to this document: https://docs.microsoft.com/en-us/power-bi/report-server/row-level-security-report-server

Best Regards,

Teige

[santosh531]

Thanks @TeigeGao 

The link provided is for .PBI file.

Any help related to implementing RLS in .rdl file is helpful.

[Karthik_Ram]

Did you find any help with this?