Compatibility Issues with Special Symbols Between Power Query and Power BI​

No, these aren't all from the same family of characters. Unicode characters are allocated into 'Blocks' and 'Planes'. Both 10004 and 10060 are in the '0 BMP' Plane, and the 'Dingbats' block. 11093 is also in the '0 BMP' Plane, but in the 'Misc Symbols and Arrows' Block. More info on this can be found here:

https://en.wikipedia.org/wiki/Unicode_block 

Therefore, it seems that Power Query does not contain all unicode characters within its 'language' set. It's not a bug. If it were up to me, PQ wouldn't contain any Unicode characters as it's just not designed for graphical output like this.

If you're really into using unicode symbols for reporting, I've attached a PBIX I made that you might find interesting/helpful. It picks up the latest unicode list from the link above, converts the codes from Hex to Decimal, and attempts to display them all in PBI with search capabilities. Enjoy 🙂

Pete

Hi Gino ,
 

While Power Query correctly displays both ⭕ and ❌, Power BI’s data model appears to misinterpret or simplify certain Unicode characters (like ⭕) during the data load, leading to inconsistent rendering.

We agree that while the workaround is effective, it doesn’t fully resolve the underlying issue.
For now, we’ll proceed with closing this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread or reopen this thread. We’ll be happy to help.

Thank you for your understanding and participation.