User based report data filter

[Hari]

Hi,

I got a requirement to filter my report data based logged in login user country.

my requirement is like I have created a global powerbi report with all my organization contries data.

Now I need to filter the report based on the login user country For ex; when US user logs in it should show only US data, like UK , DK etc.

Please let me know how to achieve this

[Anonymous · Accepted solution]

@Hari Add a User/Country mapping table to your model. Add row level security on the country table to filter based on the country associated with the user in your new table.

[Matthias]

I have the same issue.

Can someone explain this more in detail?

How can you add row level security on the country table?

Thanks