Forum Discussion

Mullz's avatar
Mullz
Frequent Visitor
4 years ago

Report filter based on Team

Hi all,   Is there a way to have one report which changes the filter based on what Team the report in accessed from? So if I add the PowerBi Report to a tab in Teams it will only show data based on...
Need Help
Show and Tell
Mullz's avatar
Mullz
Frequent Visitor
4 years ago

Hi

 

I would like essentially one dataset and one report but a page filter which changes depending on what team they are in. For instance if I had

 

Team A

Team B

 

I would want Team A to be able to use the report and it only displays projects which were tagged 'Team A'

and the same for Team B.

 

What I need though is the filter to be based on the team name that will be accessing it.

 

I'm building a power automate flow to clone a particular Team which will have a PowerBI Tab in it with the report. Rather than having to do all that manually I'd rather Have the report pick up the team name and then adjust the filter. Can teh URL Filter be set then locked so people can't change it?

 

Thanks

 

David

lbendlin's avatar
lbendlin
Super User
4 years ago

Absolutely not, that would be horrible. URL filters are default entry points, they are not restrictions. Use RLS if you need to restrict access, or use separate reports for each team.