Forum Discussion
Solved
Json.Document() ECMA-262 non-conformance - Power Query throws exception on duplicate JSON key
The following Power Query code throws an error that halts processing: let
Source = "{""key1"":""val1"",""key2"":""val2"",""key1"",""val3""}",
Custom1 = Json.Document(Source)
in
Custo...
Hi EdwardH
If your query is still unresolved, please consider raising a Microsoft support ticket. Below is the link to raise the ticket:How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
If this helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Hello EdwardH - thank you for posting to the community.
Power Query uses an implementation that does not permit duplicate keys, which aligns with ECMA-404 standards.
In order to work-around this limitation you can pre-process the JSON to remove duplicates, or handle them appropriately, before loading the data into Power Query.
Please let me know if I can further assist with this.