Excel 2016 Power Query fails to load to spreadsheet

1
votes

I utilize Power Query with most of my spreadsheet due to analyzing a large Excel data files. This is the first time that I have had an ill-defined error in loading a Power Query connection to the spreadsheet.

Excel Error - "Download did not complete:

Excel Error - "Download did not complete."

From what I can see, all the "connection only" queries are updating, and the Query updates just fine in the Query editor. There is no error in the data source as another spreadsheet with a Query from the same source loads just fine. I have turned off background refresh, sidestepped the VBA "Refresh Query" and tried a manual refresh, and turned on "Enable tracing" under Query Options. I even went directly into the connection to "Load to..." and selected "Workbook" with no luck. Every time it returns the same vague error. My team member is also having similar issues with the same report on her computer.

Any suggestions? Thank you!

2
excelvbapowerqueryexcel-2016
Do you get a more detailed error message if you hover over the query name? (In the preview pop-up). – Mistella
Also, is the query being loaded to a worksheet or a data model? Are any of the source files open when you attempt the data load? – Mistella
There is no detailed message when I hover over. The query is being loaded to the worksheet and the file was not open. – Emily
Are the source files in a shared location? – Mistella
Yes, I have posted how I resolved the issue below. Thank you! – Emily

2 Answers

0
votes

I believe the issue has been resolved. I duplicated the Query and loaded to the Worksheet again while deleting the previous sheet. It was not ideal considering all my other objects were referencing the old sheet. For some reason, the duplicated sheet loaded just fine.

0
votes

the problem will be with the initial code i.e. the columns you are importing have changed names slightly.

To fix this, reimport it in a new sheet and then copy and paste the first three lines of the import into the original!

Pleasae upvote if this helps :)