Forum Discussion
Helper ISame Report Filtered On Different Teams Pages
Helper Ipower bi in teams allows you to embed a powerbi report, instead of a weburl.
I dont know how I could utilise RLS, when mutliple people would need to access multiple teams sites.
Would I be using a teams ID instead?
Super Userjondurbridge RLS usually work based on who is viewing the report regardless which Team Channel it is published under.
- jondurbridge
Sorry - manners went out the window earlier - too easy to do that on forums.
Thanks for taking your time to reply trying to help me!
I need to somehow only have the report filter based on the teams id - the last thing I want is to try and maintain 75 separate reports, which should all be the same other than the customer
- parry2k
jondurbridge I'm very confident that you can use one report and take advantage of RLS to filter based on who is looking at the report.
Assuming you have 3 users, 2 belong to one team A and 1 belong to another team (Team B), you can implement the RLS that if Team A user is looking than what he can see and the same report if use from TEAM B is looking, he can see the same report but rows are filtered out what he is not supposed to see.
There are a lot of options available using 1 single report, viewed by different users/teams.
- jondurbridge
Unless I'm missing the obvious here
What we have is multiple customers, and then multiple staff who may access
So we could have all members of staff needing to access each customers report.
What we definitely have to have is
Teams Page For Customer A - Only show customer A in the report - regardless of who views
Teams Page For Customer B - Only show customer B ........
I just need to find something where the teams page where the report is embedded is the trigger for the filter, and not the user accessing