Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
568
Views
Topic starter
I loaded a ton of data into Power Query and did some transforming, then clicked on Close and Load to Excel. I received the error message Download Did Not Complete, and my work book now shows all of the files, but none of the data. When I go into edit, the Close and Load to Excel is grayed out. I am not sure how to modify the query now so I can try to load it successfully into Excel.
Posted : 22/01/2022 5:10 pm
Hi Julia,
From excel Data tab in ribbon, when you display the Queries in the side panel, right click that query and you'll see the Load To menu. No need to go into PQ Editor to edit the query.
Posted : 25/01/2022 1:25 am