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
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?
Stef_Farr Obviously if your actual data is sensitive then anonymise it before posting. It will be almost impossible to help further without some details about how you have your data, Roles, and Users set up.
What is the data source for your Power BI report? Is it an Analysis Services tabular model, or an SQL Server database, or something else? Knowing this will affect what the solution will be.
When a user with Role XYZ runs the report, what sort of data can they see? Can they see all data in TablesA, TablesB, but no data from TableC? Or can they see only some rows from TableA, TableB? If that is the case, then how do you configure which rows each Role can see? It must be done somewhere? Or is this still to be decided?