How to Find Excel files for named formulas including Unicode text

SunnySchindler 
That is not something power bi can do. You may follow the below post:
search - What's the best way to identify unicode encoded text files in Windows? - Stack Overflow

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Reason for my suspecting opinion "not sth Power BI can do" is since there is “Get Data from Folder” option in Power BI Desktop, wouldn't it be logical to assume Power BI will also Get Name Manager in future?

How to get assurance this will NOT be availble in Power BI? My company restrict programming and I am wishing Power BI my best shot.