Ruslan Zolotukhin on 02 Oct 2018 22:44:34
Add auto-generate Power Query (M) functions
Add several functions which will autogenerate lists for months, countries, languages (short and long), currencies and countries with languages and currencies.
It can help to create dynamic reports based on Get data from Web results.
For instance, you retrieve a list of countries with addresses of company's offices addresses on local language. If you load a funtion, mentioned above, to get countries with languages then you can dynamically translate it using some Translator API.
P.S. There is an auto-detect option in API but sometimes it can work wrong because of similar languages so result will be wrong as well.