Forum Discussion
How do i use USERNAME() dax function in my store procedure as a parameter in power bi query ?
Hi All, I have a store proceudre which has a parameter domainname. currently i am using hard coded value to get the report and its works. Now i want to pass loggedin user email id in power bi...
Sunkari
Responsive Resident
Responsive ResidentI am not sure on your approach.
But you can think of pulling all the information into Power BI and implementing RLS.
or
Creating a tabular model with RLS.
https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/
Hi Sunkari,
Thanks for the suggestion.
I have been already used RLS . As per my understanding, In RLS we can use USERNAME() function which returns logged in user name/email.
My challenge is that I want to pass this returned username or email in my SP parameter.