CUSTOMDATA DAX Function (Information) Volatile
Returns the value of the CustomData connection string property if defined; otherwise, BLANK().
Syntax
This expression has no parameters.
Return values
The content of the CustomData property in the connection string.
Blank, if CustomData property was not defined at connection time.
Remarks
This function is commonly used in implementing expressions for role-based security when an application uses custom authentication.
This function is not supported in calculated tables/columns.
IMPORTANT: there are reported performance issues if CUSTOMDATA is used in DAX expressions of the model, including RLS filters and measures, in case the connection string does not include CustomData argument. When this happens, simply passing a value to CustomData in the connection string eliminates the performance issue.
Examples
-- CUSTOMDATA returns the CUSTOMDATA argument provided in the
-- connection string.
--
-- It is mainly useful in custom security systems where the
-- caller uses CUSTOMDATA to communicate security parameters
-- to the AS DAX system
EVALUATE
{
( "CUSTOMDATA", CUSTOMDATA () )
}
Last update: Nov 14, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
Microsoft documentation: https://docs.microsoft.com/en-us/dax/customdata-function-dax