Power query functions not loading

[Yifei]

Hi all, 

I am using Microsoft 365 Apps for enterprise, I used power query for over 1 year, since last week, I suddenly couldn't load functions when I type in functions, which is super annoying. I tried unclicking and clicking the below, it just won't work, does anybody have any idea how I can resolve the issue?

Many thanks!

[v-stephen-msft]

Hi @Yifei ,

You can try the following steps to resolve the issue:

1. Make sure your Power Query version is up to date and that you have installed all available updates.
2. Disable any other add-ins that may be interfering with Power Query.
3. Try repairing the installation of Microsoft 365 Apps for enterprise.
4. Check if the data source is working correctly and try refreshing the data.
5. Try manually opening the formula list in Power Query by pressing Ctrl+Space in the formula editor.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.