DAX Function CONCATENATEX is not supported on PBIRS / DirectQuery Mode
Hi all, I tried to use DAX function CONCATENATEX using DirectQuery mode. It works fine on PBI Desktop. But when I run the report on on-prem PBIRS, the following error message "Function CONCANTENATEX is not supported in DirectQuery mode". Some DAX functions (e.g. STARTOFMONTH) is explicitly stating they are not supported in DirectQuery mode. But CONCATENATEX (https://msdn.microsoft.com/en-us/query-bi/dax/concatenatex-function-dax) has no such wordings until loading from PBIRS. My on-prem PBIRS is the latest March 2018 release. Does anyone have any idea how to resolve this? Thanks Regards, Blithe
