Forum Discussion
Row level Security not working right now?
tdimbladThe RLS is currently working with the June 2016 power bi update. You can now set up the role and rule in Power BI desktop. And it would not overwrite the role members in Power BI service, which is what is supposed to be. But on the power BI service, it still says it is a preview feature - so I guess we still can not use it for production.
samdthompson clearly not working for me. The role set up is right because I can view properly under the Test Data as Role. I have one test user and myself as members of the role. Both myself and the user see everything (report already refreshed). It is also confirmed at the test role screen if I use a view as a individual user option.
My last visit a or two weeks ago definitely worked.
By the way, does it only work under import mode? I am using direct query mode.
Anonymous wrote:
samdthompson clearly not working for me. The role set up is right because I can view properly under the Test Data as Role. I have one test user and myself as members of the role. Both myself and the user see everything (report already refreshed). It is also confirmed at the test role screen if I use a view as a individual user option.
My last visit a or two weeks ago definitely worked.
By the way, does it only work under import mode? I am using direct query mode.
Anonymous
Would you mind clarifying what RLS were you talking about? When I tried to setting security of a dataset in Power BI service it shows
And I'm not yet able to find RLS in Power BI desktop.
Hi Eric_Zhang and samdthompson I am also experiencing the same thing as you in that the Test Data as Role from the Dataset Security Menu is working on app.powerbi.com, but is not applied to the Report or Dashboard.
I am on the latest version of PowerBI (Desktop Version: 2.35.4399.381 64-bit (May/2016)), but cannot find any reference to Row Level Security in Desktop.
Lets see if a fix is made available soon?
Regards
Eric_Zhang The warning shown is a known issue. You can only set up RLS on Power BI service at the dataset level. And the preview feature does not seem to be working.
I wonder whether the issue stems from a mismatch between the May version of PB Desktop & what I would expect will be released in the June update of the tool? An older (solved) thread on this same topic led me to this article, where it talks about RLS as a feature added to the desktop. May release of the software (as of this morning, still the only version in download), this feature is missing...
Hope I'm not being just a stupid user, can anyone confirm they are missing the desktop Preview option to "Enable cross-filtering in both directions for DirectQuery" and also the "Manage Roles" option under Modelling that are mentioned in the article?
tdimblad I can confirm that it is missing. I assume it will be in the June update as you can see the article was published 2-3 days ago. Apparently Power BI team has been working on this.
