UNICHAR DAX function does not exist in Power BI Desktop

[v-yulgu-msft · Accepted solution]

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]

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]

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]

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]

What version of Power BI Desktop are you using?

The UNICHAR function was added approx 6 months ago.

[anil2]

2.56.5023.942 64-bit (March 2018)

[Phil_Seamark]

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]

[anil2]

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]

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?