Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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.
Did anyone have answers to the above questions?
Is it possible to that in latest powerBI
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
Check out and vote for this Idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13926666-provide-username-functio...
User | Count |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
114 | |
104 | |
101 | |
72 | |
65 |