Curbal

Learn how to grow your business with your data and Power BI

You are here: Home / Courses / M Language Online Course: The unofficial and Practical Reference Guide

M Language Online Course: The unofficial and Practical Reference Guide

posted on

Please log in to access your purchased courses.
Please log in to access your purchased courses.

Learn the Fundamentals of the M Language with MVP Ruth Pozuelo Martinez by taking the M Language Online course: The unofficial and practical Reference Guide.

In this course, we will go through the Official M Reference Language Guide but explain it with practical examples and exercises. See the video below for more details.

This course includes:

Who is this course for?

This course is for you that use Power Query in a regular basis and you find yourself working with the Advance Editor more and more.

It you are new to Power Query, I recommend to start with Power Query Online course first.

What are we going to cover?

In this course will will cover the following topics:

  1. Basic Values: The lower level components in M
  2. Advance Values: Tables, Lists and Records
  3. Operations in M: The type of operations you can do between basic and advance values.
  4. M Expressions: How to create simple and complex M expressions
  5. M functions: How to create simple and more complex functions
  6. M Enviroments: Did you know that M has also evaluation contexts? Here we explain what those are and how to navigate them
  7. Custom Connectors in M: We will show the components that make a custom connector and how demo how to create two connectors to get you started.
  8. Quiz: A chance to prove your mastery!

Course outline:

Basic Values

Lessons

Intro to M values Preview Null Values Logical Values Numerical values Time Values Date Values Datetimezone Values Duration Values Text Values Binary Values

Advanced Values

Lessons

Table Values List Values Record Values Nested Values Extract values from records (Field Access) Preview Extract values from lists (List Access) Extract values from tables (Item Access)

Operations in M

Lessons

Time Operations Date Operations Datetimezone Operations Text Operations Operations with Records Operations with Lists Operations with Tables

M Expressions

Lessons

Intro to M expressions Simple Expressions M syntax Let Expression Preview If Expression Error Expression Try Expression Example (function, error and try) Each Keyword

M Functions

Lessons

Intro to M functions Write M functions Invoke M functions Parameters for M functions Nested functions Recursive functions Invoke a function with Each and Try M function library Metadata Document a M function Reuse M functions

M Environments (Evaluation context)

Lessons

Intro to M Environments Simple Environments Access Child variables Access Parent variables Naming variables in different Environments Environments in Functions

Custom Connectors in M

Lessons

Intro to custom connectors Create the connector with Visual Studio 2019 Create the connector with Visual Studio Code (updated in 2024) Test the connector in Power BI Desktop and Service Section Keyword Preview Shared Keyword Authentication Publish UI Schedule refresh in Power BI Service Create your first custom connector Create a generic OData custom connector
Final Quiz and Certification