cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Change the power BI report content based on country

Hello,

I wish to make a PBI report (web and desktop both) such that a filter is applied to the report by automatically based on the user's geographical location. For example, if the user is from france, they should only be able to view the data on france and no other country. Similarly, if the user is from US, they should only be able to view the US data.

PS: Here, we do not want to have separate report for different countries, we just want to have a filter so that the user does not have to bother about the other locations

 

Thanks in advance.

1 ACCEPTED SOLUTION
Advocate II
Advocate II

You need to set up RLS (row lwvel security) i order to achieve this.

Please find the below microsoft link for the same :

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

View solution in original post

3 REPLIES 3
Regular Visitor

Thanks a lot!

I will read more about this and see if it works.

 

Cheers

Awesome , 

You can also view this {from Patrick}, exactly what you are looking for i believe , thanks 

https://www.youtube.com/watch?v=MxU_FYSSnYU

Advocate II
Advocate II

You need to set up RLS (row lwvel security) i order to achieve this.

Please find the below microsoft link for the same :

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors