Forum Discussion
How we can pass dax function username() to sql query query to fetch data only for logged in user?
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?
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
4 Replies
- Greg_Deckler
Community Champion
Check out and vote for this Idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13926666-provide-username-function-in-power-query-m-or-da
v-yulgu-msftMicrosoft Employee
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
