Newbie question about desktop Security per location

[glealla]

Hello,

I'm trying to see if it possible to create a report for 10 different people all in different locations so the data that they will see will be depends on the location that they sigh in to Power BI ? 

For example, My store in NY , so with my sign up i will see only data that connected with NY location store. (The rest locations is going to be non relevant for me)

Thanks

[GilbertQ · Accepted solution]

Hi there

What you are looking for is Row Level Security.

Below is a link from Kasper where you can try it out for yourself to get it working.

There are a lot of resources on Row Level Security that can also walk you through the steps.

https://www.kasperonbi.com/power-bi-desktop-dynamic-security-cheat-sheet/