Hey Fernan so I have a question about dynamic RLS as this is what I use in my reports with a SAP report I pull. But now comes the issue. Higher up have seen my report and really like it. Is it possible to setup dynamic RLS so that it filters by location and department. Basically we have the same departments at multiple locations but if the chief from say Germany HR logs in I only want him to see Germany and HR data, if Spain finance chief logs in they should only see spain and finance department data and can't see say Germany's data. How would one go about this? I have not found a solution and thought the only way would be to make a concatenation on all my tables with these 2 fields and then use that as my filter from my permissions table down but that doesn't seem very intuitive.
Hey there, so filtering the table with your region data is the only way I can think of to implement this dynamic RLS implementation. I have already covered this exact topic in another video here: th-cam.com/video/axTyP7I2Bso/w-d-xo.htmlsi=RjOQU32DEqx5tUlc you just need to manage the permissions table, who belong to which region and which part of your fact tables these regions should see. Hope that helps
Hi Fernan, After creating the role in power BI desktop we publish the report to service & We manually add Usernames to particular role. Is there any way to automate this process ? I mean can we automate this process- Instead of manually adding each user to their roles is there any way to automatically add the user to their roles ? Please reply
When using dynamic I just use an ALL email list we have and give everyone access to my dynamic role. Since the data is filtered dynamically from a table it will only let those users see actually data that are present on the table.
Buenos días, me podrían ayudar con algo te tengo en este momento que es aplicar ROLES a varios grupos, pero el objeto es que cuando entre una persona que tiene o que esta asociado a dicho ROL, en el dashboard se deberá ver solo lo de este grupo, el inconveniente que tengo es que el dashboard tiene seis paginas y cuando entre la persona asociada a un ROL, este debería filtrar el contenido de las seis paginas simultáneamente, no solo la primera sino todas. muchas gracias por su colaboración.
What happened with last record in dynamic RLS and please make video on object RLS too ? Thanks for detailed video !
Great video
Hey Fernan so I have a question about dynamic RLS as this is what I use in my reports with a SAP report I pull. But now comes the issue. Higher up have seen my report and really like it. Is it possible to setup dynamic RLS so that it filters by location and department. Basically we have the same departments at multiple locations but if the chief from say Germany HR logs in I only want him to see Germany and HR data, if Spain finance chief logs in they should only see spain and finance department data and can't see say Germany's data.
How would one go about this? I have not found a solution and thought the only way would be to make a concatenation on all my tables with these 2 fields and then use that as my filter from my permissions table down but that doesn't seem very intuitive.
Hey there, so filtering the table with your region data is the only way I can think of to implement this dynamic RLS implementation. I have already covered this exact topic in another video here: th-cam.com/video/axTyP7I2Bso/w-d-xo.htmlsi=RjOQU32DEqx5tUlc
you just need to manage the permissions table, who belong to which region and which part of your fact tables these regions should see. Hope that helps
Hi Fernan, After creating the role in power BI desktop we publish the report to service & We manually add Usernames to particular role. Is there any way to automate this process ?
I mean can we automate this process- Instead of manually adding each user to their roles is there any way to automatically add the user to their roles ?
Please reply
When using dynamic I just use an ALL email list we have and give everyone access to my dynamic role. Since the data is filtered dynamically from a table it will only let those users see actually data that are present on the table.
Buenos días, me podrían ayudar con algo te tengo en este momento que es aplicar ROLES a varios grupos, pero el objeto es que cuando entre una persona que tiene o que esta asociado a dicho ROL, en el dashboard se deberá ver solo lo de este grupo, el inconveniente que tengo es que el dashboard tiene seis paginas y cuando entre la persona asociada a un ROL, este debería filtrar el contenido de las seis paginas simultáneamente, no solo la primera sino todas. muchas gracias por su colaboración.