Havens Consulting
Video by: Reid Havens
Learn how to maintain your query folding when needing to merge (join) queries in Power Query, but when the merge keys are different data types, and when converting data types might initially break your query folding. Tune in to learn more!
Generative AI and language model services, such as Azure OpenAI Service, are empowering both citizen and professional data wranglers to leverage AI in building solutions ranging from simple to complex using natural language. In this session, we’ll explore how data integration developers can get started and how they can bring their own creativity to increase authoring productivity.
From financial services to felines, the World Wide Web to professional wrestling - Alex Powers has an affinity for the conventional and unconventional when it comes to information. A self-proclaimed Microsoft data & AI evangelist, he enjoys contributing to online forums, in-person training, and sharing his passion for empowering others using Microsoft technologies. Alex is currently a Senior Program Manager on Microsoft's Fabric Customer Advisory Team.
Video by: Reid Havens
Learn about a technique to to rename columns containing either CamelCase or underscore (_) title formatting in Power Query. This technique was originally posted by Jani Zajc (links below) who collaborated with Gil Raviv to create this technique, and which was inspired by a post by Chris Webb (so many people!). Tune in to learn more!
CamelCase Renaming
DataChant
Chris Webb's Post
FourMoo Other Renaming Technique
Video by: Reid Havens
Learn how to write simpler M-Code which maintains Query Folding. Features like Column from Example can be very powerful in helping you create new columns in Power Query, but the code it writes might not always fold! You can fix this with a bit of light M code edits, and maintain your Query Folding. Tune in to learn more!
Signup for our mailing list to gain access to Power BI files and templates from the videos. You’ll receive a welcome email with a link and password to the Blog Files page.
Reid Havens’ early love affair with analytics has, over the past decade, turned into an evolution into data visualization and report design in Power BI.
Since then Reid has been writing articles and creating YouTube videos to share the word of BI, helping to inspire the next generation of Business Intelligence enthusiasts.
