Column Level Security (CLS) in Paginated reports

[Sairokkam]

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. test@xyz.com | Profit
     test2@xyz.com | Discount

[v-jianpeng-msft]

Your blog is so great d_gosbell!!

Hi, @Sairokkam 

I wish you all the best.  I read d_gosbell's blog. It describes how to use the field parameters of a Power BI semantic model in a paginated report. 

Previously Super user have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

Best Regards

Jianpeng Li

[d_gosbell · Accepted solution]

I blogged about a technique for using Field Parameters in paginated reports here Power BI – Using Field Parameters in Paginated Reports – Random Procrastination