Forum Discussion
Performance Optimization for Power BI Row Level Security Model
Hi sumanthkakarla,
We sincerely apologize for the inconvenience caused.
As the issue remains unresolved, we kindly request you to raise the matter at Issues - Microsoft Fabric Community for investigation. Alternatively, you may raise a Microsoft support ticket using the link provided below. They will be able to offer specific insights related to your account and potential resolutions.
Microsoft Fabric Support and Status | Microsoft Fabric
If you find our response helpful, we would appreciate it if you could mark it as the accepted solution and provide kudos. This will assist other community members who may be facing similar queries.
Thank you.
Hi sumanthkakarla,
We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.
If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.
Thank you.
Hello v-pnaroju-msft , after implementing the bridge route still i am facing performance issue, i bealive the filters are casuing my dahboard to perform poor. so i though ot creating three new Dim tables connect to fact and now i am facing a different kind of issue , all the 3 visual filters previously coming from fact now comign from the corresponding dim table, but when i apply Dynamic RLS its not filtering the visual filters and users are seeing the entire list in the filters when he clicks on drop down list.
for example: Helath System filter is showing all the list which it suppose to restric to few helth systems where he has access and like wise for the rest of the filters. Here is how the dim tables are getting populated
Here is how i created a new 43dim tables based on fact tables,
Health System Dimension = DISTINCT('TAT Only'[HEALTH_SYSTEM])Facility = DISTINCT('TAT Only'[CLIENT_FACILITY_ACCOUNT_NAME])TEST_ID = DISTINCT('TAT Only'[TEST_ID_NAME])so if apply the Dynamic RLS then user should see only relevant health system names assiged to him instead he is seeing all, fact is not filtering the health system dimension, how can the fact should filter health system dimesnion, tried to apply cross filter direction to health system dimesnion realtion ship and its working, but cant make similar kind of change to rest of two dimesnions and i am getting this error. thats where i stuck at this point of time.
