Forum Discussion
Solved
Power Query - SQL - JSON Array - Read Æ Ø Å
Dear Community, let
Source = MySQL.Database("77.247.69.170", "concierge_admin_prod", [ReturnSingleDatabase=true]),
concierge_admin_prod_products = Source{[Schema="concierge_admin_prod",I...
Hi asamr ,
you can add a column with this formula: Json.Document([title])
This will parse the JSON string and return a record in each row that you can then expand as additional table columns.
For the umlauts, you can try to use a "replacements table" like described here: Multiple replacements or translations in Power BI and Power Query – The BIccountant
Hi asamr ,
you can add a column with this formula: Json.Document([title])
This will parse the JSON string and return a record in each row that you can then expand as additional table columns.
For the umlauts, you can try to use a "replacements table" like described here: Multiple replacements or translations in Power BI and Power Query – The BIccountant