Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 tran...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

 

What measure formula did you write when using CONCATENATE?

 

Regards,

Yuliana Gu

sapankumaarjain's avatar
sapankumaarjain
Regular Visitor
6 years ago

Hi Yuliana,

 

I was trying to create a calculated column to concatenate in direct query mode and got the same error as Subash. I was trying to join Key and Text to use in a filter.

 

Regards,

Sapan