Forum Discussion
RLS VS Scorecard & Dashboard
Hey,
I'm fighting with this issue for last few hours, wondering if someone have solution for this or simply explain to me that his mechanism works like that.
I have simple RLS on main report with data -> filter based on dax userprincipalname(). And this works perfect for me and users as it goes for Report or Dashboard form, everyone sees only dedicated data/values based on their accounts.
I decided to base Scorecard report on mentioned report (with implemented RLS).
No matter if im owner of goal, or i assign it to sombody else, in 'Value' users sees the value that is assigned to my account via RLS.
The idea was that user, in 'Value' field should see value assigned to him, as it works in Main report or Dashboard.
---UPDATE---
I verified additional scenario, I connected 'Values' without my account added to main RLS (I keept only 1 user), result was that both for me and User1 Values was shown as -. After adding back my account, mechanism reacted the same, both for me and user1 showed values dedicated for my account.
---UPDATE2---
Situation described above happened in my private Workspace, when I moved it to Workspace with premium capacity (I have admin permissions), situation changed. Under this Workspace, RLS restriction rules are completely ignored by Scorecard, and both for me and other users shows total in the Values.
It seems that in someway RLS inheriting works (difference between private workspace and shared premium workspace, but still the Values are wrong.)
Thank you for any ideas !!
Hi,
It seems, that I found answer on my own, so I will leave it here I some one will look for the solution.
According to article : https://docs.microsoft.com/en-us/power-bi/create-reports/service-goals-introduction
In section 'Issues and limitations' there is point :
- Goals don't yet support row-level security (RLS)
So for now I need to wait 🙂
3 Replies
Hi,
It seems, that I found answer on my own, so I will leave it here I some one will look for the solution.
According to article : https://docs.microsoft.com/en-us/power-bi/create-reports/service-goals-introduction
In section 'Issues and limitations' there is point :
- Goals don't yet support row-level security (RLS)
So for now I need to wait 🙂
v-yanjiang-msftCommunity Support
Hi achtoju ,
Sorry I'm not very clear what does "base Scorecard report on mentioned report" means, what's the relationship between the two reports. If the main report works fine with RLS, I think the problem is here.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your message. I will try summary the problem, hope that this will be helpfull in understanding the issue.
1. I have simple report menaged in PowerBi Desktop, I turned on the RLS filter rule on the data, its based on dax userprincipalname().
2. I uploaded this report to online premium workspsace, and turned on Security on the data set, assigned people to proper roles
3. After that I created new report (directly in online service) - Scorecard
4. I connected Value filed with values from report mentioned in 1st step.
5. Scorecard report is ignoring the RLS rules, showing the total values - not values dedicated for specific user
My question is, if I missed some step to set it up correctly or the mechanism of Scorecard report is working like that. It seems to me strange, because RLS works correctly in :