20 Power Query {M} Tricks every self-service developer should know | David Hanna

Speaker: David Kofod Hanna
Start Date: Thu, Sep 25th 2025 · 7:00 PM EEST (4:00 PM UTC)
Language: ENGLISH (with Live Translated CCs)
Location: Online (link visible for attendees)

===============================================================

Self-service developers often have excel-files, SharePoint lists, Access databases, connecting to SQL database tables or views that IT maintains, multiple files, repetitive and manual tasks. Furthermore, self-service developers aren't skilled in writing T-SQL or Python - we need another easier solution based on our competence levels and Power Query is definitely that tool!

This session will guide you through 20 tips and tricks on how to leverage Power Query and the (M)agic through UI, hidden gems and code to boost your use and understanding of Power Query.
Look forward to understand the difference between Power Query, Dataflows in Power BI and Fabric.

Whether you're just starting or looking for that one extra trick to optimize your workflow, this session covers it all.

===============================================================
Speaker: David Kofod Hanna

David is a Senior Advisor, trainer and speaker at twoday in Denmark.

David’s passion is to guide self-service Power BI developers for more enterprise manageable concepts in a consumable and practical way - because he has have been on that journey for years, and still is, thus bridging the gap between classic data engineer and business analysts.
With a decade of experience as a consultant and a background in master’s in business Intelligence,

David has advised and trained companies on the use of data from small to enterprise organizations.
Driven by both professional expertise and empathy, David stays up to date with technological advancements, specializing in Power BI, Microsoft Fabric, Tabular Editor, governance and User Experience – including certifications as MCT, DP-600, DP-700, PL-300, CPUX-F, PL-900 and certified Tabular Editor 3 Trainer.

David has a strong ability to put people first, using patience, enthusiasm, presentation skills, and a smile to achieve results that truly make an impact. Over the years, he have conducted 200+ training courses with consistently high satisfaction scores.
In his spare time, David enjoys sports like football & running and spending time with his family and kids.

Connect with David here:

https://github.com/DKH-DK/Self-Service-Power-BI-Fabric AND https://www.linkedin.com/in/davidkofod/ AND https://www.linkedin.com/newsletters/7237000963331420162/