Change the power BI report content based on country

[Anonymous]

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.

[Anonymous]

Thanks a lot!

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

Cheers

[kumar27]

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

[kumar27 · Accepted solution]

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