AD group name gets changed when adding Row Level Security
I have created a dashbaord that is meant to only show the data for the current logged in user. I followed the directions at Row-level security (RLS) in Power BI Report Server - Power BI | Microsoft Learn to set up Row Level Security to accomplish it and it works when I explicitly add a users username as a member on the Report Server. The issue I am running into is when I try to add one of our AD groups as a member, the name of the group gets an extra space added to it after it is added. I have tried multiple times typing it correctly and have double checked that it is the correct name in AD, but every time I save it the extra space is added. If I try to add the correctly typed group name while the group with an extra space is in the list, it errors out and says that something went wrong. Since the name has the extra space in it, it doesn't show a user their data on the dashboard if they are in the group. For example, I'll type in the AD group (not the actual group but same structure): "IT-GROUP-Name" and when it saves it is changed to "IT-GROUP- Name". There is an extra space added after the second dash. Any ideas? Thank you
Manage Security Roles - Row Level Security summary figures
Hi all, My dashboard shows sales and call figures for by postcode, territory, region and national levels. I have assigned Sales reps who can only view sales and calls by their territory, whilsts Regional Sales reps can view sales and calls by their region and the split by territory whilst a select group can view all sales and calls by each region and territory. Is there a way where the Sales rep can still only view their territory but can see the total for their region and the total national figure, and the same for Regional sales reps, can they view their full region breakdown but also the national roll up? The purpose is so that each viewer can see how they are comparing to 1. National Figures and 2. Their Region. Thank you in advance!!Multiple positions in organizations hierarchy RLS in Power BI server
Hello I want to apply RLS to my data as per hierarchy level , however there are multiple positions I want user to view data of users who are 2 level below him Please note I don have level column for example I want user (F) to view data for (F,G and H) same if user (C)logged in he can se data for (C,D,and E) my path is A|B|C|D|E|F|G|H Thank You in advance
Dynamic RLS with multiple tables
Hi there. I have a reasonably complicated dynamic RLS which i am trying to resolve through dax. Attached is the schema. The premise is the Id in the user table is the USERRPINCIPALNAME The user has a a list of companies they are allowed access to in the USERALLOWED table These companies have a relevant ID called InstanceId-CRMId that gets passed into a site list and on to the report to limit the data. The issue i am haivng is i do not want to have to use bidirectional relationships There iaremany to many relationships Performance is poor I cannot seem to get the RLS to properly work and the sites table isnt filtering when I add ID = USERPRINCIALNAME() in the user table. Can someone suggest specifc dax for this use case please??? I have looked at some RADACAD posts on this example but can't work it out. Thanks in advance!!
Default values for slicer
Hi All I am pulling out what little hair I have left with this particular issue related to setting the default value of a slicer for a dashboard that has been configured for Dynamic Row Level Security. Here is my scenario. I have created a dashboard for dynamic row level security using the bridge table technique and then I have published the dashboard to our in house report server (not the service) and tested the data displayed using myself and another member of the team. There is a slicer setup as a single select to choose one of Company A,B,C, or D, It has to be a single select because the data is specific to one company not multiple. I have access to see Company A and B and my team member has access to see Company C and D. All this works perfectly and when I sign on I see A and B and my team member can see C and D. But when I published the dashboard, Company A was selected (because its the first one in the list) and this gets persisted with the published dashboard. Now when my team member signs on she sees that Company A is selected in the slicer and C and D are listed below it. No data is returned for A but its annoying because she only should see C and D. Now for rant time...... When is Microsoft going to sort out this defaulting issue for slicers. There are so many work arounds for defaulting date periods for latest month, etc and I am sure there is a workaround that some clever person is going to give me for my above problem 🙂. BUT SSRS and now even Paginated Reports have had this for ages by having a separate query that is used to supply the default value for a single select or multiple select parameter. When is this seemingly simple idea going to filter or bubble up to the top of the ideas list. I, and most probably half the Power BI family across the world have votes for this but nothing yet. Please Microsoft, you have a wonderful product and all the better now that Fabric has landed but please give us an easier out the box method to have default values for a slicer. Feel better now, comments appreciated.
