Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
MattKarriker2
Helper II
Helper II

Impersonate Users for Security Role Performance testing

I have a case where a user is unable to execute a specific report.  Other users have no issues executing the report.  The difference between the users are their assigned roles in Power BI dataset.  I am looking for a way to impersonate the user having the issue to further isolate the issue.  

 

Our environment is Power BI Premium.  We have a XML read/write end point in place and normally use SSMS and DAX Studio to test performance.  Both SSMS and DAX Studio have the EffectiveUserName parameter available which historically has been used for impersonation in SSAS.   For some reason both SSMS and DAX Studio throw the below error when I use the EffectiveUserName in the connection string.  Has anyone been able to use EffectiveUserName property of the connection string using DAX Studio to troubleshoot security role performance issues?

 

The '<pii>xxxxx@xxxxx.net</pii>' value of the 'EffectiveUserName' XML for Analysis property is not valid.

3 REPLIES 3
Greg_Deckler
Community Champion
Community Champion

@MattKarriker2 In the Service, find the Dataset, click the ellipses and go to Security. Hover over a role, click the ellipses and choose Test as role.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler This is a step we have completed.  The report runs as expected.  But still the users are not able to execute the report in service.  

@MattKarriker2 Is there an error or do they just not see anything? If they don't see anything, try having the user use the "Reset to default" in the Service.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.