Skip to main content
Microsoft Idea

Power BI

Planned

Create a view scenario where you can impersonate a viewer of a dashboard/report so that we can see exactly what the consumer sees.

Vote (52) Share
Jason Himmelstein's profile image

Jason Himmelstein on 30 Jan 2015 05:26:03

Create a view scenario where we can impersonate a named user so that we can see exactly what the consumer sees when they view a dashboard or report.

Administrator on 27 Oct 2015 06:56:31

We are planning to do this for data that is stored in the cloud. What models were you particularly interested in?

Comments (6)
Jason Himmelstein's profile image Profile Picture

Scott Peterson on 07 Apr 2023 18:30:30

RE: Create a view scenario where you can impersonate a viewer of a dashboard/report so that we can see exactly what the consumer sees.

I have users with the same roles and permissions where one person can see a workspace and another cannot see the workspace. I need to be able to log in as the specific user to be able to troubleshoot to see if it is a license issue, a role issue, a permission issue, or a RLS issue, as far as I know, this is not currently possible.

Jason Himmelstein's profile image Profile Picture

Jason Himmelstein on 30 Aug 2021 12:11:02

RE: Create a view scenario where you can impersonate a viewer of a dashboard/report so that we can see exactly what the consumer sees.

This has been "Planned" for almost six years now according to this post. Is there any update on this?

Jason Himmelstein's profile image Profile Picture

Janet Garcia on 08 Apr 2021 15:07:44

RE: Create a view scenario where you can impersonate a viewer of a dashboard/report so that we can see exactly what the consumer sees.

I need impersonation at an individual user level. We have security tied to PRINCIPALUSERNAME() and need to ensure each person can only see their own data. We are using the Power BI Service to publish our reports and datasets. There is the ability to impersonate a named user on the reports that are part of a dataset (with very obscure steps to get there). But any reports that are linked to another dataset (Using PowerBI Dataset as the data source) don't have this option. Just to test my security, I have to risk exposure of data by relying on a user who *should* be limited, but who might not be. Not acceptable.

Jason Himmelstein's profile image Profile Picture

Rory Neary on 05 Jul 2020 22:46:41

RE: Create a view scenario where you can impersonate a viewer of a dashboard/report so that we can see exactly what the consumer sees.

Hi You can create a role in the pbix and then once in power bi navigate to the role within the dataset/security and click 'test as role'. It's not perfect but it can be useful.

Jason Himmelstein's profile image Profile Picture

Power BI User on 05 Jul 2020 22:17:38

RE: Create a view scenario where you can impersonate a viewer of a dashboard/report so that we can see exactly what the consumer sees.

I'm not exactly sure what you mean by models - but what if data isn't stored in the cloud?

Jason Himmelstein's profile image Profile Picture

Jonathan on 05 Jul 2020 22:16:32

RE: Create a view scenario where you can impersonate a viewer of a dashboard/report so that we can see exactly what the consumer sees.

We currently need a second machine to be logged in as a market specific user to test reports. We build very general reports and let role level security built into our data model a lot of filtering but have no good way to view/test reports as a user.