Forum Discussion

Aruna_ln's avatar
Aruna_ln
Helper III
7 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

 

which one best

I am new in the M langage i am learning this

 

please suggest me which one best or performance

 

Thanks

Aruna

 

Need Help

4 Replies

  • zoloturu's avatar
    zoloturu
    Memorable Member
    7 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
      7 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