Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
oitp
Helper I
Helper I

Permissions inside a report

Hi, is it possible to use permissions inside a report? Here is an example.

 

Person A, B and C all report how much time they spend on different projects. These persons all want a view of their own time to see how much time they have spent on all of their projects.

 

Person A should only see his/hers time, B only his/hers and so on.

 

Do I need to build seperate reports for all the persons/users or can I have 1 report with permissions to each own "user"?

1 ACCEPTED SOLUTION
v-diye-msft
Community Support
Community Support

Hi @oitp 

 

 

I think you're referring RLS, Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. 

Here're some posts for your reference:

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

Helpful posts:https://radacad.com/row-level-security-configuration-in-power-bi-desktop

https://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

3 REPLIES 3
v-diye-msft
Community Support
Community Support

Hi @oitp 

 

 

I think you're referring RLS, Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. 

Here're some posts for your reference:

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

Helpful posts:https://radacad.com/row-level-security-configuration-in-power-bi-desktop

https://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Thanks alot, this is most likely what i need 🙂

amitchandak
Super User
Super User

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.