Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
@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.
I have the same issue.
Can someone explain this more in detail?
How can you add row level security on the country table?
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.