Hello PowerQuery experts,
I'm trying to migrate a PowerQuery formula from Power BI PowerQuery to Excel PowerQuery, I was expecting that both PowerQuery implementations were the same but unfortunately, it is either not the case or I fall on some localization issues (French vs English) please found the partial erroneous query and the error message I'm getting in Excel. I guess is about some immutability issue but unclear has I'm no way expert of Power Query.
= Table.Pivot(#"Expanded ""tags"" from Records", List.Distinct(#"Expanded ""tags"" from Records"[name]), "name", "value") Expression.Error: Sorry ... We were unable to apply the < operator to the List and List types. Details : Operator=< Left=[List] Right=[List]
Here the full code excluding APIs Keys pointing to the faultive line: https://gist.github.com/EricLacroix/e6313e893f3f107f22eccfb79cddadb7#file-gistfile1-txt-L81