Forum Discussion

Yifei's avatar
Yifei
New Member
3 years ago

Power query functions not loading

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!

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.