How we can pass dax function username() to sql query query to fetch data only for logged in user?

[arunkumar112]

How we can pass dax function username or userprinciple name to sql query to retrive data for power BI report. We don't want to load all data then apply filter. only load data only for logged in user name. 

Using procedure 

RetriveDataForLoggedInUser(@StartDate,@EndDate, @LoggedInUserName)

Please suggest?

[Anonymous]

For Direct Query I use the SQL function SYSTEM_USER in a stored proecedure to get the calling users credentials. I can then use that to filter or mask the output as required. Hope this helps.

[Anonymous]

Did anyone have answers to the above questions?

Is it possible to that in latest powerBI

[v-yulgu-msft · Accepted solution]

Hi @arunkumar112,

Currently, we cannot pass the DAX function Username to sql query. As Username is not a supported function in Power Query. Here is a blog listing four ways to get USERNAME in Power Query. 

Regards,

Yuliana Gu

[Greg_Deckler]

Check out and vote for this Idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13926666-provide-username-functio...