Power Query Editor Window Freezing

%3CLINGO-SUB%20id%3D%22lingo-sub-970034%22%20slang%3D%22en-US%22%3EPower%20Query%20Editor%20Window%20Freezing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-970034%22%20slang%3D%22en-US%22%3E%3CP%3ELooking%20for%20help%20in%20Excel%20for%20Office%20365.%26nbsp%3B%20I%20load%20excel%20files%20all%20the%20time%20through%20Power%20Query%20and%20recently%20it's%20freezing%20when%20I%20open%20the%20Power%20Query%20Editor%20window.%26nbsp%3B%20it%20happens%20both%20when%20I%20try%20to%20Transform%20or%20Edit%20data%20after%20it's%20loaded%20another%20way.%26nbsp%3B%20I%20get%20the%20Power%20Query%20Editor%20window%20opn%20but%20it%20doesn't%20display%20any%20data%20or%20let%20me%20access%20the%20header%20rows%20for%20any%20functions%2C%20etc.%26nbsp%3B%20A%20screenshot%20is%20attached%20and%20thank%20you%20for%20any%20help.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-970034%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1644171%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20Editor%20Window%20Freezing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1644171%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F437761%22%20target%3D%22_blank%22%3E%40DEHarris%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20same%20problem%2C%20lags%20so%20much%20that%20I%20can't%20even%20use%20my%20mouse%20to%20close%20the%20editor%20again.%3C%2FP%3E%3CP%3ERunning%20on%20a%209th%20gen%20i7%2C%2016gb%20RAM%2C%20RTX2060m.%3C%2FP%3E%3CP%3ENice%20to%20see%20the%20problem%20still%20being%20ignored%20almost%20a%20year%20later.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Looking for help in Excel for Office 365.  I load excel files all the time through Power Query and recently it's freezing when I open the Power Query Editor window.  it happens both when I try to Transform or Edit data after it's loaded another way.  I get the Power Query Editor window opn but it doesn't display any data or let me access the header rows for any functions, etc.  A screenshot is attached and thank you for any help.  

1 Reply
Highlighted

@DEHarris 

 

I have the same problem, lags so much that I can't even use my mouse to close the editor again.

Running on a 9th gen i7, 16gb RAM, RTX2060m.

Nice to see the problem still being ignored almost a year later.