Forum Discussion
Over 600 Roles needed
Hi Stef_Farr ,
You could try to set dynamic row-level-security in Power BI.
Please take a look at these blogs.
https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple
https://blog.pragmaticworks.com/dynamic-row-level-security-in-power-bi
Best Regards,
Jay
Hi Anonymous ,
The different roles need access to the same Power BI report via Power BI Service. Basically I need to create one report connected to a database. Each user will access the same report but needs to see only the data that pertains to that user.
Stef_Farr The Power BI report will need to know the username of the user viewing the report. I am not familiar with how to do this in Power BI Service. I assume that you want to limit the rows of data that each role can see, not the columns. In which case I would suggest reading up on Row-level security (RLS) in Power BI.
Row-level security (RLS) with Power BI - Power BI | Microsoft Docs
How will the report know which data that UserXYZ can see?
Hi Anonymous ,
Yes that is what I was asking about. My issue with this and hence my question:
- How to have it as automated as possible? Imagine we have a new recruit, I don't want to have to go through the process to add a new role and upload the pbix to the Power BI service all the time.
- If it allows you to create this many roles?
- Should I be using another method, considering this many roles?Stef_Farr A few questions to help me understand better:
Can a User have just one Role, or many Roles?
Is it the Role that drives what data can be seen, or the User? i.e. is it possible for there to be two different Users with the same Role(s) but they should see different data? Or would two Users with same Roles see exactly the same data?
How often would a new Role be created?
Hi Anonymous , Yes of course, ask me. Really need help with this. I use roles with my reports all the time. But this one with so many roles got me thinking.
A role might have more than one user.
The role will determine what data can be seen.
If there are 2 different users with same role, they will see same data.
A new role can be created often - more than once per week.