(Livestream Replay) #PowerQueryEverything with Copilot for Data Factory - with Alex Powers

DESCRIPTION 📄

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.

GUEST BIO (Alex Powers) 👤

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.

RELATED CONTENT 🔗

Twitter
LinkedIn

Automatically Rename CamelCase Columns in Power Query!

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!

RELATED CONTENT 🔗

CamelCase Renaming
DataChant
Chris Webb's Post
FourMoo Other Renaming Technique

Keeping Query Folding by Outsmarting Columns from Examples in Power Query

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!

RELATED CONTENT 🔗

Tabular Editor Learn
Query Folding

Improving Merging & Appending Power Query (Queries) with Ken Puls

Video by: Reid Havens

Learn an improved way to merge or append queries (as new) by adding an additional source applied step. Ken Puls will walk you through this, and why it'll benefit your query logic moving forward. Tune in to learn more!

GUEST BIO 👤

Ken Puls is the president of Excelguru Consulting Inc, a company dedicated to helping users get the most from their data. A blogger, software developer, author and trainer with over 20 years of accounting and IT experience, Ken's passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. Learn more about Ken at the links below!

RELATED CONTENT 🔗

Ken's Twitter
Ken's LinkedIn
Company Website
Company Blog
MonkeyTools