Forum Discussion
String concatenation not working in Direct Query mode
Hi All,
I am trying to concatenate 2 strings in query editor (in Direct query mode).
But i am getting the below error while applying the changes in query editor.
"This query contains transformations that can't be used for Direct Query".
Can anyone please help me on this issue.
Thanks,
Subash
7 Replies
That's odd, according to this: https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/dax-formula-compatibility-in-directquery-mode-ssas-2016?view=sql-server-2017
CONCATENATE should be supported in all DAX formulas.
Hi Anonymous,
It is not available to add custom column to concatenate 2 strings in Query Editor mode when data connection is live. As a workaround, you could create a report lelvel measure with DAX function: CONCATENATE
Best regards,
Yuliana Gu
Hi Anonymous ,
What measure formula did you write when using CONCATENATE?
Regards,
Yuliana Gu
