Skip to content

It's Not About The Cell

Hiding The Gridlines That Hold Us Back

  • Home
  • About
  • Am I interested in writing a book?
  • Contact
  • Portfolio
  • Resources

Recent Posts

  • That’s So Meta
  • Cleaning the (Staging) Lakeside
  • From Pipelines to Table: The Outputs We Ingest
  • CHANGE (IN THE HOUSE OF LAKES)
  • It’s a LongType() to the top (If you want to rock and roll)

Power Query

It’s a LongType() to the top (If you want to rock and roll)

I’ll always be the first to admit that the things that interest me may be of little (technical) interest to you. However, I figure “Hey, why not just start documenting my random gibberish findings?!” and well, here we are with a short but sweet article on Dataflows Gen2 in Microsoft Fabric. Backstory: I’ve always been […]

Read more "It’s a LongType() to the top (If you want to rock and roll)"

5 Tips for Learning Data Types in Power Query Formula Language

This entire article was generated using Bing‘s GPT, in somewhat of a weird experiment to see how it would respond to the prompt – “Can you provide me a blog post idea about teaching someone how to learn the data types in the Power Query formula language, using complete paragraphs to describe each suggestion” – […]

Read more "5 Tips for Learning Data Types in Power Query Formula Language"

The (Almost) Definitive Guide to Query Folding

There’s only one rule. Don’t break the fold! Before we start enforcing all these rules, we should start with something like a solid foundation of what does and doesn’t fold in Power Query and their SQL equivalents. Now, if you found this page and we’re like “what in the world is query folding?” read this […]

Read more "The (Almost) Definitive Guide to Query Folding"
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok