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,

 

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Yuliana Gu,

 

When i am using the CONCATENATE function in dashboard level, i am getting below error.

 

 

Thanks,

Subash

  • 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Were you able to find any solution? I am facing the same challenge right now.

    • 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

  • sapankumaarjain's avatar
    sapankumaarjain
    Regular Visitor
    6 years ago

    Same here. I am also getting same error