Please explain Power Query VS M language

[Aruna_ln]

HI Any explain which one best perfomance given

example:

Power Bi query:step by step my opreation exa: deleting rows,grouping rows ete..

M language:same operation i am writing in the M lanhuage

which one best

I am new in the M langage i am learning this

please suggest me which one best or performance

Thanks

Aruna

[zoloturu]

Hi @Aruna_ln,

Are you trying to compare Power Query (Excel) and M (Power BI)?

Regards,

Ruslan

[Aruna_ln]

inside Power Bi itself only

which one is best writing M language inside Power Query or we will operation using button(top Power BI navigation bar)

example:

Method1:I am grouping my source using Power Query Grouping Button 

Method2:same grouping i am using M language

which one good using Button or M langauage

[v-juanli-msft]

Hi @Aruna_ln

For any user who are not very familiar with the M language, it is better to use top Power BI navigation bar to accomplish one's goal.

If the function in top Power BI navigation bar can't meet user's requirement, you need to write M language in Advanced editor to achieve your goal.

For your scenario, if two method all meet your requirement, it is easily to use Power Query Grouping Button.

Best Regards

Maggie 

[Thejeswar]

@Aruna_ln,

Creating something as a step in Power Query would essentially add a statement in M Query. So not very sure as to what difference would it make speaking about the performance.

AS per my understanding. where M Query would make a difference is when you wat to customise a created step, doing it using M-Query would give you a great flexibility