how to Enable IntelliSense in Power BI Service

[Divyanshu15]

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

[Divyanshu15]

@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]

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

[Anonymous]

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