Forum Discussion
Helper ISame Report Filtered On Different Teams Pages
Super Userjondurbridge check this link for URL filter, also check if RLS makes
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
more sense in this case.
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?
- parry2k
jondurbridge 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.