SQL Query how to call table function with value of USERPRINCIPALNAME()

[sekic]

In query editor I try to call table function which have one varchar input parameter.

When parameter is constant, return rows are fine.

In SQL Profiler I can see that Power BI call comand such as "select ... from function('[email protected]')"

But when try to use USERPRINCIPALNAME() as value (either as USERPRINCIPALNAME() or as Text.From(USERPRINCIPALNAME())) response is invalid, because Power BI call is "select ... from function('USERPRINCIPALNAME()')" or

"select ... from function('Text.From(USERPRINCIPALNAME())) ')".

It use constant 'USERPRINCIPALNAME()' instead of value of dax function USERPRINCIPALNAME().

How to send real value to table function?

[Anonymous]

Hi @sekic,

Current USERPRINCIPALNAME function only available on report view, you can't use it in power query custom function.
In my opinion, you can try to get all records and use dynamic RLS to filter data.

For detail information about dynamic RLS, you can refer to below links:

Power BI – Dynamic Row Level Security – Tips to get it working!

Tutorial: Dynamic row level security with Analysis services tabular model

Regards,

Xiaoxin Sheng