Rinkesh Tracker

Re: How do i use USERNAME() dax function in my store procedure as a parameter in power bi query ?

Rinkesh — Tue, 19 Sep 2017 12:44:44 GMT

Hello Eric,

Thanks for the response but i dont want to restrict users to see their only own data. I want to display the records for all users who have same business unit in CRM . The username will be used only for getting the BU from systemuser table in CRM.

please find the below sql query so that requirment can be explained better.

declare @domainname varchar(50)
set @domainname ='rinkesh.rathor@xxxxxx.com'
select * from lead L
inner join systemuser S on S.id = L.ownerid
inner join businessunit B on B.id = S.businessunitid
where L.owningbusinessunit = (select businessunitid from systemuser where domainname=@domainname)

Thanks,

Rinkesh

Re: How do i use USERNAME() dax function in my store procedure as a parameter in power bi query ?

Rinkesh — Mon, 18 Sep 2017 07:10:06 GMT

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.

Re: How do i use USERNAME() dax function in my store procedure as a parameter in power bi query ?

Rinkesh — Mon, 18 Sep 2017 06:36:10 GMT

Is there any workaround ?

Re: How do i use USERNAME() dax function in my store procedure as a parameter in power bi query ?

Rinkesh — Mon, 18 Sep 2017 04:52:42 GMT

Can anyone help me over here ?

How do i use USERNAME() dax function in my store procedure as a parameter in power bi query ?

Rinkesh — Thu, 14 Sep 2017 10:55:48 GMT

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 ='rinkesh.rxxxx@XXXXXXs.com

Can anybody help me how do i achieve this?

Thanks,

Rinkesh Rathore