how to pass value to a role from DAX Studio

[Anonymous]

I have a composite model, where my user's table is a direct query and the rest of the data is import. 

I would like to use DAX Studio to analyze the DAX performance by passing the user. 

Without "viewing as a user" I am able to get the visual back in 300 ms - 400 ms, but on the PBI Service when the user is viewing the same visual it is taking 200,000ms +, I am trying to analyze this using DAX studio so that I can break my measure in multiple pieces by adding/removing the complex logic. But, I am not able to find how I can run the measure definition in DAX Studio with the security as a user(role).

[Greg_Deckler]

Best to ask @marcorusso. Is your RLS code complex? 

[Anonymous]

@Greg_Deckler: Thank you, for the reply.

For this report, RLS code is simple, just the volume of data going to SQL server and getting back and the summarizing, that being said I have some complex DAX in the measure (Ranking, sorting, grouping and sum)

[marcorusso]

Use Effective User Name in connection dialog box as explained here:

https://daxstudio.org/documentation/features/connection-dialog/

[Anonymous]

@marcorusso : Thank you, I did try adding the user, but I am getting error.

Maybe because of my security on the role us not with AD Account?

This report is embedded in a custom portal and I get the UserID from our custom portal.

[marcorusso · Accepted solution]

You need to be an admin of the Analysis Services engine to do this. Try to get the exact username to use by using Profiler as an admin. If you are using Power BI Desktop to test this, you might want to simulate this with a local username. If you are trying to connect to Power BI Service, I'm worried you cannot simulate another user because you are not an administrator.

If you use the Power BI Desktop feature to test a role, you can use the same technique. If you cannot test the role locally, you might be in trouble because you are not an administrator of the backend AS engine used by Power BI.

[Greg_Deckler]

Thanks @marcorusso figured you would be the person who would know!

[Greg_Deckler]

Hmm, maybe it is something going on with the interaction between the two sets of DAX code. I wonder if you could emulate that interaction by combining the code in an evaluation statement in DAX Studio?