Forum Discussion
Row Level Security No Longer Working?
Hi - I used the preview RLS feature on Tuesday and it worked exactly as described. Now today, I uploaded a new copy of my .pbix file and went to add my RLS rules and they are not working at all. It lets me add the rules, but they don't seem to ever take effect. I have tried everything I can think of in case maybe I am doing some steps differently today than I did on Tuesday, but I cannot get RLS to work. Has something changed in that timeframe?
Brynn
Another update: RLS is now working for me as described in the PBI documentation. I am able to apply the RLS in my personal workspace and distribute it via content pack to a user and it works! This is great and now I will just wait for the same functionality to be available in the group workspace :).
Thanks!
Brynn
21 Replies
I just added my original report for which RLS worked on Tuesday back into the PBI service and tried to apply the security rules the same way I did on Tuesday and today they don't work. I wish I could figure this out. Is RLS working today for other people?
I am trying the capability as well and see not effect of the RLS when I drag the column into a table expecting to only see the filtered items vs all of them.
This feature is still not working for me.
I am having an issue using this RLS feature as well, and created a simple test by pulling top 1000 rows from sample MSSQL database.
SELECT TOP 1000 [ProductID]
,[Name]
,[ProductModel]
,[CultureID]
,[Description]
FROM [AdventureWorks2014].[Production].[vProductAndDescription]Uploaded the Pbix file to Power BI, and set up the following straight foward rule:
I verified that I am part of the Members, and I am doing this in My workspace. However, when I go to the report after doing a refresh, I can still see all rows.
However, I am able to get RLS to work on Direct-Query against Teradata connection with a very similar rule.
I am having the exact same issue as above - very simple RLS rule with 3 members in the Role, but it behaves as if no rule has been applied and shows all data for all users.
Hi,
I had the same problem, again a very simple filter syntax, that would not get propagated to the users.
Realized that if i clicked the "..." of the Role name, and "Test data as role" it was working as intended tho.
so it is definitelly not a syntax issue, but mapping the rule on the users.
can anyone do "test data as role" and re-confirm that it works there?
BR,
D
bspillar KirkNason just tested this out with the report I setup RLS in few days ago as well as new report published today and it worked fine in both. Have you checked DAX that you use to apply rules? Maybe syntax error or column or value doesn't exist. When I was setting this up I also noticed if you don't have user signed up to powerbi.com and you try add them it will not work. But in that case it won't let you SAVE.
ankitpatira Thank you for your reply. It is interesting to hear the RLS is still working for you. The DAX I am using is incredibly simple. The field exists and the value I am using also exists. In addition, I tried to the set up with even simpler data where I had a single table and still it would not work for me. I think you may be onto something about the users having to be added. The users for me come from our corporate system and the specific users I am testing with are set up with PRO licenses. I did notice the first time I used it I added the users with their corporate email by typing in their entire address and the next time when it was not working the system would pop up the users for me from the corporate system. I submitted a ticket with PowerBI,but haven't heard anything back yet. It is just odd it was working and now it's not. When you enter your users do you enter their entire email address, or does the entry box pop up the list of users as you type and you select one? Once a user is added do you see their email address or last name, first name?
Thanks for helping me troubleshoot.
Brynn
bspillar As I type in email address of users I want to add it will come back with entry box with list of users (as they woudl have already singed up for PBI) and I select it from there. Once user is added I only see their first and last name.
