Hello All,
I have been experiencing an issue with Get & Transform (Power Query). When I attempt to Get Data from a file folder and edit the data in the Power Query Editor, the Editor window freezes. The steps I am taking are:
Get Data > From File > From Folder > [Navigate to the folder] > Combine & Edit
Once I get to the Power Query Editor window, nothing else happens. I don't see a preview of my data, and I am unable to click on any of the ribbon buttons, or even cancel out of the window. I actually have to Ctrl + Alt + Delete and force close Excel in order to escape.
I have tried this with small and large .csv files saved both locally AND on my network shared folder(s) with the same result. I have performed an online (full) repair on Office twice.
Has anyone else experienced this? I have been able to perform these steps many times before, and it seems like it just stopped working within the last few weeks.
I am using MS Office 365 and am currently working on Version 1808 (Build 10730.20334)
Bookmarks