Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |