Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Hari
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
Seth_C_Bauer
Community Champion
Community Champion

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


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

2 REPLIES 2
Seth_C_Bauer
Community Champion
Community Champion

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


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.