Since March 2021, Power BI desktop doesn't display translations but it works in the service once it's published. You can revert to Feb 2021 to make it work again.
As far as I know, the technique used in the blog post is the only one which provides automatic translations without registering in any translation website or paying for a translation service. Translations maintenance and validation are easy. The new Excel plugin version from July 2021 makes it much faster than before.