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

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

HI anil2

 

That should be recent enough.  Perhaps it is the value you are passing to it.  Are you trying to pass text???

 

What happens if you try to generate the calculated measure I suggested in your model?

 

Test Measure = UNICHAR(128077)

 

 

anil2's avatar
anil2
Frequent Visitor
8 years ago

 

  • anil2's avatar
    anil2
    Frequent Visitor
    8 years ago

    Phil,

     

    I am able to create that function in a new powerbi report.

    But that function is not showing in my existing report. I am not sure why. I cannot recreate my existing report because there are so many views in my report.

    We are using live conncetion to data source.

    • Phil_Seamark's avatar
      Phil_Seamark
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi anil2

       

      I wonder if the function is only working in import mode then.  Are you connecting to an Analysis Services  Cube as your live source?  Could you add the calculated measure to that?