Forum Discussion
Column Level Security (CLS) in Paginated reports
Hello all,
I'm trying to implement Column level security/OLS in Paginated reports.
Created CLS using Field parameters in PBI Dataset published to service, which is working fine.
When creating paginated report on top of Dataset, not sure how to call/implement parameter to Dataset in paginated report, Any suggestions how to achieve this.
Reading data from SQL Server, Table A contains sales data (ID,Sale_Amount,Profit,Discount). CLS is applied on Profit and Discount columns.
Table B contains (Email and respective columns that have access)
ex. [email protected] | Profit
[email protected] | Discount
1 Reply
Hi Sairokkam
Please refer to the following post:
Object Level Security for Report-Server - Microsoft Fabric Community
If the above post do not solve your problem, I suggest you ask your question in the Report Server forum, where more professional engineers can help you solve your issue.Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
