Skip to main content
Microsoft Idea

Power BI

New

Dynamically filter report on currently signed in user

Vote (2) Share
Daniel Willén's profile image

Daniel Willén on 01 Nov 2022 14:32:04

We need a way to pass the current user viewing the report to use as a filter for power bi data. Row level security requires extra setup. A dynamic field to be used as a parameter would be enough. Ideally it would be great if we could pass paramters into a report to change the way it behaves or what data it shows.

Comments (1)
Daniel Willén's profile image Profile Picture

Heidi Croft on 01 Nov 2022 21:06:06

RE: Dynamically filter report on currently signed in user

Sharepoint already allows you to specify views in lists to only items requested by {me}. We have scorecards we would love for our customer service reps to be able to utilize to check their performance but considering there are hundreds and the turnover for reps is quite high, we have not rolled it out because we don't have the resources to manage the row level security for each one.