Forum Discussion

bspillar's avatar
bspillar
Advocate I
10 years ago
Solved

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 l...
  • bspillar's avatar
    bspillar
    10 years ago

    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

slybri123's avatar
slybri123
Regular Visitor
10 years ago

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.

 

 

SnoJa10's avatar
SnoJa10
Advocate IV
10 years ago

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.