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

Permission to see only user own items/records on PowerBI report

Hello All,

 

I was wondering how to set up permission in a PowerBI report so that users only can see thier own records/items.

 

The data is coming from SharePoint.

PowerBI-1.png

 

Thank you in advanced.

 

1 ACCEPTED SOLUTION
nnkaya
Regular Visitor

I found answer. Thanks this guy. He is explaning it very cleairly and nicely.

https://youtu.be/BBWUv2JijJs

View solution in original post

5 REPLIES 5
nnkaya
Regular Visitor

I found answer. Thanks this guy. He is explaning it very cleairly and nicely.

https://youtu.be/BBWUv2JijJs

View solution in original post

nnkaya
Regular Visitor

Hello @mussaenda ,

 

I know about it. But how to set it up.  

For example: [Name] = USERPRINCIPALNAME()

or something else?

PowerBI-2.png

mussaenda
Resident Rockstar
Resident Rockstar

Hi @nnkaya ,

 

Once you are finish setting it up, 

Upload it on the service and set the users under security

mussaenda
Resident Rockstar
Resident Rockstar

Hi @nnkaya ,

 

Please try to use the RLS (Row Level Security) that you can find under Modeling -> Manage Roles

I would appriciate if you could please write step by step guidance.

Thanks

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.