Forum Discussion
Solved
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 main...
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
Stef_Farr You will need some way to configure in your database which Roles are associated with the relevant data, and also a UserRole table. Can you give an examle of a couple of Roles and what data they can see?
Hi Anonymous . No unfortunately at this moment I cannot share data, as I am looking at my options to build the database/report around them.
But what you are telling me sounds interesting. Can you elaborate more please?