I have an existing model that has been working great but today it is throwing errors. Specifically when trying to import Calendar data from Exchange Online, the Web API throws a failure during Power ...
Here is an even simpler repro:
let
Source = Exchange.Contents("[email protected]"),
Calendar1 = Source{[Name="Calendar"]}[Data],
#"Filtered Rows" = Table.SelectRows(Calendar1, each [Start] > #datetime(2019, 12, 31, 0, 0, 0)),
#"Extracted Values" = Table.TransformColumns(#"Filtered Rows", {"Categories", each Text.Combine(List.Transform(_, Text.From), ";"), type text})
in
#"Extracted Values"