Develop | BI & Reporting

Data & BI Summit

PUGDV08 - Introduction to M Programming

Wednesday, April 25
09:00 - 10:00
Room: Liffey Hall 2

Format: Presentation
Level: Yes - A
Level: Intermediate

When you’re loading data into Power BI and Excel there’s a lot you can achieve in the Query Editor just by using the user interface. However, everything you do in the Query Editor is converted to code in a language called M and in more advanced data loading scenarios you’ll need to know how to write M code. In this session you’ll learn what kind of scenarios you’ll need to use M as well as the fundamentals of the language. You’ll also see several practical examples of how to use it, for example separating connection details out from queries to make them easy to update; creating and using functions; handling missing or changed data sources; and calling web services.




Chris Webb

Director
Crossjoin Consulting Limited

Chris Webb is a UK-based consultant and trainer specialising in Power BI and SQL Server Analysis Services. He is a frequent presenter and conferences and user groups all over the world including the PASS Summit, SQLBits and SQL Saturdays, and has written or co-written several books and white papers including "Power Query for Power BI and Excel" and the Microsoft white paper "Planning a Power BI Enterprise Deployment". He blogs about Microsoft BI at https://blog.crossjoin.co.uk/

Presentation(s):

Send Email for Chris Webb


Assets

Introduction to M Programming



Attendees who have favorited this

Send Email for Introduction to M Programming