cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
glealla New Member
New Member

Newbie question about desktop Security per location

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Newbie question about desktop Security per location

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/

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
1 REPLY 1
Super User
Super User

Re: Newbie question about desktop Security per location

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/

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 316 members 3,424 guests
Please welcome our newest community members: