Forum Discussion
Parameter selection to table
Hi kodiejames13 , you can use row level security for this, although you'd have to prepare your data accordingly.
https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security
I should have mentioned(I've since updated the post) that this data will be sent via email using BI report builder using the semantic model.
Thanks kodiejames13 are you using a semantic model stored in PBI service in Report Builder? If so you will need to define RLS in the dataset itself stored in service. It's unnecessarily complicated to implement RLS in Report Builder directly unless you are comfortable with VB code.
For our purposes we chose to implement it on SQL side as it was the most simplistic solution that worked for us when using paginated reports.
IF the emailed RDL file will contain an embedded dataset, I'd heavily emphasize on creating separate datasets and reports for each client so as to absolutely prevent unwanted data leaks. That is assuming each of your clients are distinct organizations. Otherwise you are risking legal liability.