Passing username a parameter to Query

[Anonymous]

As of now we are loading all the Records from SQL Server and apply Row Level Security at PowerBI level to implement Data masking. We are seeing performance issues to load all the user Records . Can any one provide details of passing username as a parameter to SQL Query to fetch only the respective user Records. 

I understand that there is no option to pass Dax Function UserPrincipalname() / username() to SQL query from the Power Query editor. 

[amitchandak]

@Anonymous , I doubt that is possible.

@ImkeF , is that possible?

[ImkeF]

Hi @Anonymous ,
there is no native function to get the usernam in Power Query.
And using the SQL-Current_user function would only fetch the service account under which the dataset is refreshed.

[Anonymous]

Hi ImkeF, 

Yes you are correct . Even I have tried the SQL -CurrentUser() , this is returning the Service account which is configured for Data Refresh.

Not sure if any one had tried  "SQL Server Row Level Security". I am not sure whether this would work for this problem. 

https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-serve...