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
Icon for Microsoft Employee rankMicrosoft 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
      Icon for Microsoft Employee rankMicrosoft 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

      Same here. I am also getting same error