Forum Discussion
Teams and RLS
I have my dashboard, report and its dataset in the workspace. I have set up the RLS and have shared it with my team. Up to here is all fine and when team members are accessing it, it works fine.
The issue arises with MS Team. MS Teams is similar to Skype and you can collaborate with your colleagues and is part of Office 365. In the Teams, you can share Sharepoint folders, calendars and Power BI dashboards. So, when I share it in the Teams, the RLS completely fails. The same person who has limited access to the Dashboard in Power BI can now access the same file through Teams but can see the whole dataset.
I hope it makes sense.
Hi Jawed
Not sure about what steps you have applied.
According to this article, to let RLS work, you need to add MS Team in the dataset->Security->add members
If you previously defined roles and rules in the Power BI service, you must re-create them in Power BI Desktop.
Please review this thread, i hope thia may give you some idea
https://community.powerbi.com/t5/Service/Microsoft-Teams-Pro-Licence-Required/td-p/90339
Best Regards
Maggie
- Jawed7 years agoHelper III
Thanks for sharing the links. I have gone through them and can confirm that my setting in the Power BI Desktop and the Service is all as it has been recommended. Contrary to the content of the thread you shared, my colleagues, who have Power BI licence, can view the Dashboard on Team. My problem is that they see all the information on Team. What it means is that the same people in Power BI Service can only see their relevant information but when using the same dashboard in Team, they can see everything.
Hope that makes sense.
Thanks
- Jawed7 years agoHelper III
I havent been successful in finding the solution and would be grateful if one of the moderators can help me out on this.
- Jawed7 years agoHelper III
I havent been successful in finding the solution and would be grateful if one of the moderators can help me out on this.
- JonV7 years agoHelper II
From what I've read previously, members of the workspace (which is managed by Teams), can always see all of the data. RLS simply won't work.
Workspaces were really intended to be used for developers; not end users. Rather end users should have dashboards and reports shared with them individually, where RLS will work.
The new app workspaces should also allow for RLS, so if users access it that way, it should work as well, but app workspaces are still undergoing a lot of changes, so I can't guarantee that's how it's working in the current release.