rls problems

2 Topics

Power BI Global Role Level Security
To any one reading this, I was wondering if you have come to a situation where you implement RLS on all of your reports (let say about 30). The RLS is set so that users assigned to site A Active Directory (AD) group can only see data for site A, users assigned to site B (AD) group can only see data for site B, and so on. For example, let say I have a fact table for Sites and I create RLS on this table and my RLS are: SiteA --> filter created is --> [site] = A SiteB --> filter created is --> [site] = B The issue now is that when a new sites C, D, and so on are open, then all reports need to be updated to add a new RLS and corresponding assignments need to be done in the portal. For example: SiteC --> filter created is --> [site] = C SiteD --> filter created is --> [site] = D Is there any good solution for something like this where each report won't need to be updated everytime a new site is added? I am looking for a way to set global RLS for all the reports in my environment or something that could work similar to this. If it exists, I am not aware of it. Thanks in advanced for your feedback.
Solved
yoismelp
4 years ago Place Desktop
1.8KViews
0likes
2Comments
Problems viwing data in Power Bi apps
Good morning to all. Recently I've created a report for people to see their respective data (RLS). I've created a dynamic RLS and created an app in power bi. On my desctop application and on the "Apss" part of power bi web, the test works just fine; I can see the data when I "test as Role". When the end user tries to see the data what they obtain is: Identificador de actividad: 2b5f3138-1a65-474a-b67f-dbec1a99affd Identificador de la solicitud: 2534c1a7-5b90-46d1-b5f6-91b3c02c824f Id. de correlación: 9b02bfc3-7174-0ad8-7a66-686d8cc8c35b Hora: Thu Oct 28 2021 16:45:09 GMT-0400 (hora de Bolivia) Versión del servicio: 13.0.17018.56 Versión del cliente: 2110.3.08222-train URI de clúster: https://wabi-south-central-us-redirect.analysis.windows.net/ and they can see the background but no data whatsoever. Can somebody, please, guide me or tell me how can i fiz this issue. Thanks in advance
Anonymous
4 years ago Place Desktop
2.3KViews
0likes
9Comments