Forum Discussion

Hari's avatar
Hari
Frequent Visitor
9 years ago
Solved

User based report data filter

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

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      Matthias
      Frequent Visitor
      8 years ago

      I have the same issue.

      Can someone explain this more in detail?

       

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

       

      Thanks