cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
olimilo
Helper V
Helper V

Per user level RLS?

Is it possible to use Power BI with RLS on a per user level? By per user, I mean similar to how a user would log in to a system and only be able to see his personal profile. The end result would be to create a dashboard for each person where they can see their ratings per field and what development paths they can take to go to another job role.

1 ACCEPTED SOLUTION
vanessafvg
Super User
Super User

@olimilo do you mean dynamic row level security?

 

http://radacad.com/dynamic-row-level-security-with-power-bi-made-simple





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
vanessafvg
Super User
Super User

@olimilo do you mean dynamic row level security?

 

http://radacad.com/dynamic-row-level-security-with-power-bi-made-simple





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




View solution in original post

Hi @vanessafvg! I think that's the one I'm looking for. Do you think it's possible to use this with an Excel file as a data source?

@olimilo Well once the data is imported into power bi I would think the source is irrelevant since power bi will manage the security in the power bi file - however that wouldn't extend to excel obviously - probably best to read through the link to make sure it meets your requirements 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




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.