Forum Discussion
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!
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!
Wow, it is working.
Respect pbikaelin !
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
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.
Just checked: the save button will work in my case only for 3 names maximum.
All my users are already in our AAD.
it worked - thanks so much !
