cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
patlaff Frequent Visitor
Frequent Visitor

Row Level Security not allowing new entries

As of this morning, I'm noticing a new issue in the Power BI Service where, under the Security section of my Dataset Settings where I have RLS enabled and configured, all of my current role assignments are still there, but I cannot add any new ones.  When I type an email into the text box, no suggestions come up, and the "Add" button is never illuminated, even if I enter a full, valid email address.  I am an owner of my workspace, and other owners are seeing the same problem. I have also confirmed I am seeing this same behavior across my company's tenant, as well as my client's tenant. Please advise on how to resolve.

1 ACCEPTED SOLUTION

Accepted Solutions
pbikaelin Frequent Visitor
Frequent Visitor

Re: Row Level Security not allowing new entries

If you are really desperate, this appears to work.

Once you've navigated to the RLS view, append the URL in the browser with 

?unmin=1

This will force rendering of the full JS instead of the minified version.

 

Using your browser Dev Tools (F12 to open for Chrome/Edge), navigate to the Sources (Chrome) or Debugger (Edge) tab.

Following the script hierarchy, open:

app.powerbi.com / 13.x.x.x / externals / ngTagsInput.js

 

Find line 259 and set a breakpoint - the line should read:

if ($scope.tags.length >= $scope.options.maxTags)

Go back to your browser and refresh the page which should trigger your breakpoint.

 

Use the JS Console to run this command:

$scope.tags = []

You can now resume the script execution by pressing the resume (play) button.

 

You should now be able to manage RLS. You will need to repeat these steps again as you navigate to additional datasets.

 

Have fun!

View solution in original post

9 REPLIES 9
pbikaelin Frequent Visitor
Frequent Visitor

Re: Row Level Security not allowing new entries

I'm having the same issue. Multiple browsers, multiple users.

Fairly urgent issue since no new users can be configured via RLS.

 

I've also found that the "Access" tab has been inconsistent in the "publish app" workflow - same username list control?

In this case, not all of the added users are visible in the box, the auto-complete doesn't work reliably and duplicates are added.

32Jan New Member
New Member

Re: Row Level Security not allowing new entries

 

I had the same issue.

 

It was gone after i set the report to default values. (the little arrow counterclockwise)

 

Hope that helps.

 

Jan

mestopinal Frequent Visitor
Frequent Visitor

Re: Row Level Security not allowing new entries

I'm having the same issue.  I discovered a related issue last week as well where I could add the person but the Save button wouldn't work.  With that I was able to work around it and click to a different role and the "Do you want to save" window would pop up allowing me to save.  But now I have nothing.  This needs to be fixed urgently.

pbikaelin Frequent Visitor
Frequent Visitor

Re: Row Level Security not allowing new entries

If you are really desperate, this appears to work.

Once you've navigated to the RLS view, append the URL in the browser with 

?unmin=1

This will force rendering of the full JS instead of the minified version.

 

Using your browser Dev Tools (F12 to open for Chrome/Edge), navigate to the Sources (Chrome) or Debugger (Edge) tab.

Following the script hierarchy, open:

app.powerbi.com / 13.x.x.x / externals / ngTagsInput.js

 

Find line 259 and set a breakpoint - the line should read:

if ($scope.tags.length >= $scope.options.maxTags)

Go back to your browser and refresh the page which should trigger your breakpoint.

 

Use the JS Console to run this command:

$scope.tags = []

You can now resume the script execution by pressing the resume (play) button.

 

You should now be able to manage RLS. You will need to repeat these steps again as you navigate to additional datasets.

 

Have fun!

View solution in original post

MarcinBajda Frequent Visitor
Frequent Visitor

Re: Row Level Security not allowing new entries

Wow, it is working.
Respect @pbikaelin  !

mestopinal Frequent Visitor
Frequent Visitor

Re: Row Level Security not allowing new entries

One more thing I was able to do to get it to work that's hopefully a bit simpler, and this is basically the idea from 32Jan's post, so credit there, is click around on your dashboard in the web service (toggle a slicer, for example; just clicking on data doesn't seem to trigger the "Reset to Default" button) so that the "Reset to Default" button becomes available.  Then click the Reset to Default button and then navigate over to the RLS security page and it suddenly allowed me to type in new names and save.  Had to do this a few times though as it decided to stop working after I had saved a few roles.  

 

Obviously just a workaround for a bug and not a true fix, but it could get you out of a jam

Highlighted
joelbuxton Frequent Visitor
Frequent Visitor

Re: Row Level Security not allowing new entries

it worked - thanks so much !

Ghuiles Regular Visitor
Regular Visitor

Re: Row Level Security not allowing new entries

@mestopinal that would be a good idea, but the reset button did no work in my case.

 

But, c'mon Microsoft has to correct his bug quickly! How to otherwise manage properly long lists of users on different dashboards?

 

BR, G.

Ghuiles Regular Visitor
Regular Visitor

Re: Row Level Security not allowing new entries

Just checked: the save button will work in my case only for 3 names maximum.

All my users are already in our AAD.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 443 members 4,624 guests
Please welcome our newest community members: