rls

70 Topics

Role Level Security
Hi, I haven't been using power Bi too long and I have a RLS question. I tried using Claude but with no success. My question is as followed: I have a stats table with the following fields: Period, TkD, Name, Hours and Amount. When user A logs in, I only want user A to see his information along with user B and C. When user B logs in, I only want user B to see his own info and no one else. User C can see everyone's information including his own. What do I need to do to set up this kind of RLS? Thanks. Jack
Solved
Phantom1980
2 months ago Place Report Server
1KViews
0likes
5Comments
PowerBI January 2026 Update - On-Premise Reporting Server
I have noticed a bug with RLS Pbix files, where the normal behavior in our May 2025 environment was giving greyed out visual and not showing the data, after upgrading to January 2026 on test environmnet. the behavior has changed and it automatically refreshes indefinitely until an RLS is set. the page keeps reloading with error 401 unauthorized.
Solved
MTerkait
5 months ago Place Report Server
1.5KViews
0likes
5Comments
RLS in Sep 2025
Hi All, More Information: i upload the existing pbi report which made by 202409 desktop to 202509 PBIRS. I found an issue that the pbi report will refresh itself infinitely, if an user is not assignned in "RLS" page and enter that pbi report. the report was created by 202409 pbi desktop for RS. you can reappear this case by creating an empty pbi report with role and uploading to PBIRS, then entering it by yourself. i have tested for two times. this is different from previous version of PBIRS. there are almost 100 up pbi reports in my PBIRS. i am afraid of: 1. rebuilding every pbi reports mannually and uploading them. 2. affecting RLS feature in older version pbi report.
Solved
Vanchy_Liao
7 months ago Place Report Server
2.1KViews
0likes
11Comments
Row Level Security - SSAS/Report Server
Hi everybody, I have been struggling lately about how I should implement the "RLS" so that it is reflected in the power bi dashboards. In other words, 1- First, I have designed a SSAS project and implemented roles using dynamic rls and also added desired members 2- Then I deployed the project on an Analysis Server database 3- Creating live connection in power bi and designed my dashboard 4- uploaded the .pbix file on the report server (on-premise). 5- Although I have defined rls in ssas visual studio, all users can see all of the information? and this is something that bothers me. Note: I analyzed my SSAS project in Excel and all RLS configs are working like a charm. (RLS in Power bi -> Not ok, Excel -> Ok) Is there anything else that I am missing which leads to this outcome? I greatly appreciate your help. Thanks, Kasra
Solved
Anonymous
8 months ago Place Report Server
2.5KViews
0likes
9Comments
PowerBI - RLS for External Users
Hi Community! I created a RLS for a PBI, but some people are outside of the organization. When I go on the Semantic model > Security > and I add people to the User group, I get the error "some people are outside of the organization". Is there a way to fix this? Thank you!
Solved
mcaraff
11 months ago Place Report Server
2.2KViews
2likes
2Comments
RLS Not Applying When Added/Saved from Power BI Report Server, but Works After Re-uploading it
Hello, Power BI Community, I am experiencing a critical issue with Row-Level Security (RLS) that seems to depend on the workflow used to apply it. When I configure RLS directly opening in edit mode from Power BI Reporting Service, the security rules do not take effect, even though they appear to be set up correctly. The security rules only become active after the report is downloaded and then re-published from the Desktop application. Has anyone else encountered this behavior? Is this a known issue, or am I missing a step when configuring RLS directly in the service? Any help or insight would be greatly appreciated. Thank you
Solved
Maverik91
1 year ago Place Report Server
1.4KViews
0likes
5Comments
when add Domain's security group to RLS of Power BI Report Server , error occured in report page
Hi all The security group named ‘PBIGroup’ have crteated already in domain environment, while add the ‘PBIGroup’ to the RLS on Web site , there is no error in current page , but go to report page, the error "This visual contains restricted data.See details" occured for every visuals. while add individual user account to this rls box, the report page works well. i refer to the link Row-level security (RLS) in Power BI Report Server - Power BI | Microsoft Docs. there is a limit like below, but there is no other details or configuration guidance to describe the "NTLM or Kerberos authentication" so how can i make the security group work for the RLS of Power BI Report Server, there is other steps is missing? the document link Configure Kerberos to use Power BI reports - Power BI | Microsoft Docs is the right one to solve this group rls issue ? note: the data source is SQL Server any suggestions is welcome , thank you for your help! Best Regards Amy
Solved
Meng
1 year ago Place Report Server
1.9KViews
0likes
4Comments
For Dynamic Row Level Security do I still need to add members on power BI service?
How can I fully implement Dynamic Row-Level Security (RLS) in Power BI without having to manually add users to the role in the Power BI Service under Semantic Model-> More options → Security → Add members? Context: I've implemented Dynamic RLS using a SQL database that contains user emails, and I'm using the USERPRINCIPALNAME() DAX function to filter data based on the logged-in user. This works as expected in Power BI Desktop using the "View as Role" feature. However, in the Power BI Service, some users are unable to see the filtered data unless I manually add them to the RLS role. Since the filtering logic is already dynamic and based on the user's email, I was hoping to avoid this manual step. Is there a recommended workaround or best practice to automate this process and ensure users are recognized by the RLS logic without needing to be explicitly added to the role? under Semantic Model -> More options → Security → Add members?
Solved
ananda31
1 year ago Place Report Server
4KViews
2likes
8Comments
RLS and Parameters Issue
Hi everyone, I’m running into an issue with a visual in my Power BI report that uses RLS (Row-Level Security) and parameters. The report includes a table of email addresses (used as the principal user field), which connects correctly to two other data tables. RLS is working as expected across the report—except for one bar chart visual that uses parameters in the axis. Here’s the setup: The X-axis uses a parameter to switch between different measure fields. The Y-axis uses another parameter for slicer-based values. Both parameters are also available as slicers so users can control how the chart displays. The issue: When a user selects a value from a parameter that isn’t related to user identity, the visual shows totals for all users instead of just their own data. This breaks the RLS logic and exposes data they shouldn’t see. I’ve tried applying filters at the visual, page, and report level, but nothing seems to restrict the visual to only the RLS-filtered data. It seems like the parameters may be overriding or bypassing the RLS filtering somehow, but I’m not sure why. Has anyone experienced this before or have any ideas on how to resolve it? Thanks in advance!
Solved
JoeHeraty
1 year ago Place Report Server
1.1KViews
0likes
3Comments
Email subscription screenshots with RLS applied
Hello, I have a report that shows aggregated data for multiple companies. I would like to send a daily email to a contact in each one of the companies that contains a screenshot of the report, filtered to the data for that company. I have published the report to the power bi service, set up a subscription and applied RLS in the report to ensure data is filtered to the relevent company when the subscribed user clicks on the link in the email. This all works as expected, however the screenshot does not show filtered data based on the user, rather it shows the aggregation of the entire dataset. Is it possible to show a filtered view in the email screenshot? Or have I missed something when setting up the subscription and RLS? Many thanks, ahurley
ahurley
1 year ago Place Report Server
4.1KViews
0likes
8Comments