Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to 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
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
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)
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
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.
What version of Power BI Desktop are you using?
The UNICHAR function was added approx 6 months ago.
2.56.5023.942 64-bit (March 2018)
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)
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.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |