Forum Discussion
Over 600 Roles needed
Hi,
I am working on a Power BI project. I need to create over 600 roles to give different access of the data to each role. I need to do it, such that, it is not something that I have to keep maintaining with every new recruitment. How can I do this? And should I use roles or something else in Power BI?
Thanks.
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
11 Replies
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
Thanks so much Anonymous . This should work. I'll try it out.
Stef_Farr Do the different roles have access to different Power BI reports?
Or do all users have access to all reports, but different roles can only see subsets of the data?
Will this project be Power BI Service, or Power BI Report Server? Or something else?
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?
