(Livestream Replay) Create your own Power Query Connector for Power BI & Dataflows - with Miguel Angel Escobar

DESCRIPTION 📄

Ever wanted to connect to a data source that is not listed in Power BI or Dataflows? This session will show you everything that you need to know to better understand the landscape of connectors in Power BI and Dataflows, how to connect to sources not listed in Power BI and when / how to create your own connector for Power BI and Dataflows.

GUEST BIO (Miguel Angel Escobar) 👤

Born and raised in Panama City, Panama. I’m currently a Program Manager at Microsoft for the product that changed my life: Power Query. Before this Program Manager role, I was the Principal Consultant and President of my own company based in Panama called Powered Solutions which was a Microsoft Gold Partner in Data Analytics for many years. I'm a former Microsoft MVP, MCP, MCT and author of books related to Data Prep and Data Analytics.

RELATED CONTENT 🔗

Miguel's LinkedIn
Creating Your First Connector
Power Query SDK Overview

(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