cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Hari Frequent Visitor
Frequent Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: User based report data filter

@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.

Near SE WI? Join our PUG Milwaukee Brew City PUG
2 REPLIES 2
Super User
Super User

Re: User based report data filter

@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.

Near SE WI? Join our PUG Milwaukee Brew City PUG
Matthias Frequent Visitor
Frequent Visitor

Re: User based report data filter

I have the same issue.

Can someone explain this more in detail?

 

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

 

Thanks

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 122 members 1,479 guests
Please welcome our newest community members: