Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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('abc@xyz.com')"
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?
Solved! Go to Solution.
Hi @sekic,
USERPRINCIPALNAME() is a DAX function, it's not available in Power Query. When you connect to SQL Server database, Power BI use Power Query then generated T-SQL to get data. The USERPRINCIPALNAME() will be treated as a text than passed into table function.
In your scenario, please try to use the RLS on Power BI side. See: Row-level security (RLS) with Power BI.
Best Regards,
Qiuyun Yu
Hi @sekic,
USERPRINCIPALNAME() is a DAX function, it's not available in Power Query. When you connect to SQL Server database, Power BI use Power Query then generated T-SQL to get data. The USERPRINCIPALNAME() will be treated as a text than passed into table function.
In your scenario, please try to use the RLS on Power BI side. See: Row-level security (RLS) with Power BI.
Best Regards,
Qiuyun Yu
Ok, is there any data, except constant, which can be send from Power BI to SQL, in query editor, as argument to function?
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('abc@xyz.com')"
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.