Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Syndicate_Admin
Administrator
Administrator

What is M language in Power BI?

 
1 ACCEPTED SOLUTION
VahidDM
Super User
Super User

Hi @JimJim 

 

The M language, also known as the Power Query M formula language, is a powerful and functional language used in Power BI and Power Query to manipulate data. It is case-sensitive and shares similarities with F# in terms of functionality12.

Here are some key points about the M language:

Functional Language: M is a functional language, which means it focuses on the declaration and composition of functions to transform data.
Data Mashup: It is primarily used for data mashup, which involves filtering, combining, and transforming data from one or more supported data sources1.
Power Query Editor: In Power BI, the M language is supported only within the Power Query Editor, which is the tool used for data transformation and preparation2.
Wide Application: M language is embedded in various Microsoft products, including Excel, Power BI, Analysis Services, and Dataverse, enabling repeatable data mashups3.
Rich Function Library: The M language features nearly 1000 unique functions that can be used to perform a wide range of data manipulation tasks4.
The M language is integral to Power BI and Power Query as it provides the underlying code that runs the data transformation processes. When you use the graphical interface of Power Query to perform tasks like filtering, sorting, or merging tables, M code is generated in the background. This code can be viewed, edited, and written manually to create more customized and complex data transformation processes.

 

Check this link:
https://learn.microsoft.com/en-us/powerquery-m/m-spec-introduction

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

View solution in original post

4 REPLIES 4
VahidDM
Super User
Super User

Hi @JimJim 

 

The M language, also known as the Power Query M formula language, is a powerful and functional language used in Power BI and Power Query to manipulate data. It is case-sensitive and shares similarities with F# in terms of functionality12.

Here are some key points about the M language:

Functional Language: M is a functional language, which means it focuses on the declaration and composition of functions to transform data.
Data Mashup: It is primarily used for data mashup, which involves filtering, combining, and transforming data from one or more supported data sources1.
Power Query Editor: In Power BI, the M language is supported only within the Power Query Editor, which is the tool used for data transformation and preparation2.
Wide Application: M language is embedded in various Microsoft products, including Excel, Power BI, Analysis Services, and Dataverse, enabling repeatable data mashups3.
Rich Function Library: The M language features nearly 1000 unique functions that can be used to perform a wide range of data manipulation tasks4.
The M language is integral to Power BI and Power Query as it provides the underlying code that runs the data transformation processes. When you use the graphical interface of Power Query to perform tasks like filtering, sorting, or merging tables, M code is generated in the background. This code can be viewed, edited, and written manually to create more customized and complex data transformation processes.

 

Check this link:
https://learn.microsoft.com/en-us/powerquery-m/m-spec-introduction

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

JimJim
Responsive Resident
Responsive Resident

Hi @VahidDM , thank you for this wonderful explanation, but it wasn't me who asked the question 🙃

Oh sorry

but the id is same as you!

 

regards

vahid

manvishah17
Resolver III
Resolver III

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.