Forum Discussion

anil2's avatar
anil2
Frequent Visitor
8 years ago
Solved

UNICHAR DAX function does not exist in Power BI Desktop

  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi anil2,

     

    Based on my test, if we are connecting to SSAS tabular cube in Direct Query mode, UNICHAR() function is not supported. 

     

    Best regards,

    Yuliana Gu

10 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi anil2,

     

    Based on my test, if we are connecting to SSAS tabular cube in Direct Query mode, UNICHAR() function is not supported. 

     

    Best regards,

    Yuliana Gu

    • sdjensen's avatar
      sdjensen
      Solution Sage
      8 years ago

      I just made a small test and it seems like it depends on the compability level of your model, which makes perfectly sence. UNICHAR is not supported in Analysis Services before compability level 1400 and will only work in Power BI if you create a measure when connected to a model with this compability level (or above)

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    HI anil2

     

    It should do, you just need to 1) make sure the value you use is base-10 and a valid unichar character and 2) use a visual that supports them

     

    Measure = UNICHAR(128077)

    produces a thumbs up

     

    • anil2's avatar
      anil2
      Frequent Visitor
      8 years ago

      Thanks. But I am seeing a redmark under UNICHAR when i am trying to create a mesue. It looks like function not available on my destop  version. Please suggest.

       

      • Phil_Seamark's avatar
        Phil_Seamark
        Microsoft Employee
        8 years ago

        What version of Power BI Desktop are you using?

         

        The UNICHAR function was added approx 6 months ago.