Shout out to all the people that complained about Google
Month: May 2026
Well, that’s interesting!
PowerQuery vs. JSON null or empty list
I had an interesting problem recently when the JSON output from an API started to return a null value instead of empty list. This broke my PowerQuery so I wanted to share a fix.
Originally, I used the built-in “Extract values (from a list)” feature, which concatenated them to make comma separated values:
= Table.TransformColumns(#"Removed Columns", {"List_Field", each Text.Combine(List.Transform(_, Text.From), ","), type text})And that worked fine. Until the content of that field was not a list. Evidently, this field had previously contained an empty JSON list if it contained no values. I’ve never looked at the JSON itself so I had no idea. So, when the API started returning null for that field instead List.Transform failed:
Expression.Error: We cannot convert the value null to type List.
In some of my other Queries it was also failing “silently” because this step was immediately followed by a RemoveRowsWithErrors step. Whoops. Having no idea that the API output had changed (or what it originally contained) was my big problem here. Took me a while to understand what had gone wrong and how.
The fix itself isn’t complex, simply check if the value is a list before concatenation:
= Table.TransformColumns(#"Removed Columns", {"List_Field", each if Value.Is(_, type list) then Text.Combine(List.Transform(_, Text.From), ",") else null, type text})However, that DOES make me wonder why the built-in doesn’t automatically add code to check the type. Can’t be that hard…
Thirty years after defeating the Galactic Empire, Han Solo and his allies face a new threat from the evil Kylo Ren and his army of Stormtroopers.
I still think that, comparatively, this is one of the better films outside the original trilogy but it’s still pretty bad.
This time I was struck by the scene in which Han and Leia explain their relationship to each other…
★★★
Thirteen-year-old Mei is experiencing the awkwardness of being a teenager with a twist – when she gets too excited, she transforms into a giant red panda.
This review may contain spoilers.
I watched this with my 11 year old daughter and, as an armchair feminist, I was so confused…
[Some spoilers ahead]
The panda as a metaphor for hormones, coming-of-age and finding your true self – works 100% for me. Big thumbs up, I liked it. I liked Mei and her weird friends a lot. The fact that Mom suspects first period, when panda first appears, is also quite funny and sweet and positive. In fact, not mentioning it, given the circumstances, would feel like an omission. So, that’s really great.
However, during Mom’s subsequent stalking, presumably prompted by concern regarding panda, she bizarrely decides to use first period as a cover story. This weirdly entangles the two themes, resulting in both appearing as a potential source of embarrasment and shame AND then later something to be trapped, controlled and hidden. So, that all felt really negative.
But, I can’t tell if that entanglement was entirely unintended. Maybe that’s an intended reflection of societal attitudes: little girls, stay in your box and keep your feminity hidden?
[Major spoilers ahead]
If that’s the case, I don’t feel like the movie goes on to challenge that. If anything, it leans into it. At the end, I found myself hoping that all the women would keep their “panda” and celebrate it.
Ultimately, I’m not sure what an 11 y/o girl takes away from this.
★★★½ (contains spoilers)
“Do that with Acrobat”
I can’t even view a PDF, Adobe. WTF have you done? Morons.