Forum Discussion

Regular Visitor

9 years ago

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...

Icon for Responsive Resident rank

Responsive Resident

9 years ago

I don't think this is supported in Power BI Service.

Regular Visitor

9 years ago

Is there any workaround ?

Sunkari
Responsive Resident
9 years ago
I 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/
- Rinkesh
  Regular Visitor
  9 years ago
  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.
  - Eric_Zhang
    Microsoft Employee
    9 years ago
    Rinkesh wrote:
    
    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.
    
    Rinkesh
    
    It is not possible and there's no workaround. As you've already used RLS, you can alter the SP to retrieve data for all domain users and apply RLS to restrict those users to see their own data.

Related content