Forum Discussion

Aruna_ln's avatar
Aruna_ln
Helper III
8 years ago

Please explain Power Query VS M language

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 ...
Need Help
zoloturu's avatar
zoloturu
Memorable Member
8 years ago

Hi Aruna_ln,

 

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

 

Regards,

Ruslan

Aruna_ln's avatar
Aruna_ln
Helper III
8 years ago

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's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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's avatar
    Thejeswar
    Super User
    8 years ago

    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