Forum Discussion
Solved
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 ...
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
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