M Query in Power BI

M QUERY:-

• M stands for Data Mashup.
• M is a functional and case sensitive language.
• A power query is a data extraction and transformation tool.

EXAMPLE:-

• An example, Remove a column in the table by using the M query. In M query write a code of remove column.

STEP1:- The first step GET DATA to connect to the SQL server.

GET DATA FROM SQL SERVER

STEP2:- Provide the Server name and Database name.

STEP3:- Select the table and click on ok

LOAD THE TABLE

STEP 4:- Then, Click on edit queries → Advanced editor. In advanced editor write M query.

• Query formula starts with the let statement. Output a query formula using the in statement

ADVANCED EDITOR

• When clicking on the done button displays the result.

RESULT

If you are new to Power BI starts with the following must-watch video: -