Forum Discussion

Rinkesh's avatar
Rinkesh
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 online as a parameter. ishort SP should be looked like as below example.

 

Example :  Exec SPLead @domainname ='[email protected]

 

Can anybody help me how do i achieve this?

 

Thanks,

Rinkesh Rathore

10 Replies

    • Sunkari's avatar
      Sunkari
      Icon for Responsive Resident rankResponsive Resident

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