In Power BI Row-level security (RLS) is used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles.
Define Roles in Power BI Desktop
Step-1: Import Data to Power Bi Desktop using Direct Query connection :- Import Data in power Bi
Step-2: Under Modeling Tab, select Manage Roles
Manage Role In Power Bi
Step-3: After that create roles for users then click to Save.
Watch Video for step by step process-
Limitation
In Power Bi Service, RLS doesn’t restrict this data access in Power Bi Workspace, members of a workspace have access to datasets in the workspace.
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.
Do we need to give workspace reader access to that user