Forum Discussion

Divyanshu15's avatar
Divyanshu15
Frequent Visitor
2 years ago

how to Enable IntelliSense in Power BI Service

Hello Everyone,

 

I have an issue with the M query intellisense suggestion

For eg- When I'm writing the Function for Date, It does not suggested all Date-related functions, I have to type all the functions manually, I'm Not able to see the option of intellisense setting in the Power BI service(Not desktop) settings also.

 

Kindly suggest how can i overcome this 

 

Best Regards

Divyanshu

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Divyanshu15 ,

     

    --  When I'm writing the Function for Date, It does not suggested all Date-related functions, I have to type all the functions manually.

    Could you give an example of which function is not showing up?

    Assuming we want to use the Date.AddMonths function, I would start by typing 'dateaddm'+Tab to enter it.

    We can also type 'dateadd' and use ↑↓ + Tab to select the desired function:

     

    -- I'm Not able to see the option of intellisense setting in the Power BI service(Not desktop) settings also.

    My approach is to temporarily edit in Desktop and then paste the M code from the Advanced Editor into PowerQuery Online. 

    Please help PowerBI do better by voting for similar ideas:

    M Intellisense powerquery online

     

    Best Regards,
    Gao

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

  • Divyanshu15's avatar
    Divyanshu15
    Frequent Visitor

    Anonymous It's not about the Date function only, it's just for example, I'm talking about any Function whether it's Text, Value, or Any, below is the window where I'm try to Write the Date Function, But Nothing works 

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Divyanshu15 ,

       

      Yes, M IntelliSense is not yet available in PowerQuery Online. ğŸ˜‘ So I would write it in PowerBI Desktop (or some external tool) and then paste the code into PowerQuery Online (Dataflow, etc).

       

      Best Regards,
      Gao

      Community Support Team