Report Filter by User

[udian]

Hi,

I have a PBI report retreiving data from excel in shrepoint. The report is published to the PBI service.

The report has a filter for region. Right now the region filter is accessible for the user so that a user can see other users sales information. I want to change the report so that the region filter won't be visible and will be filtered according to the user running the report.

Is this possible?

Thanks! 

[Anonymous · Accepted solution]

@udian Yes, you can accomplish this by setting up Row Level Security (RLS) - > https://docs.microsoft.com/en-us/power-bi/desktop-rls