Power Query not loading data - Stalling

MTtroy

New Member
Joined
Jul 7, 2018
Messages
9
Recently I have had both relatively small power queries (180 rows, 10 lines of M code) and larger (approx. 6000 rows, 25 lines of M code) stall at the load stage. It happened first with the larger query and I thought it had to do with the size of the query. But it has now happened with smaller queries as well. I have never successfully loaded the above queries, but can load other queries just fine.

If it is loaded to a sheet, it will load a small portion of the query (15% of the query output rows, the last row consists of 3 periods in each column and then stall without loading anymore data. The Workbook Queries status bar shows that the query is still loading, but never goes anywhere.

The same result if I load it to the data model without anything at all showing up in the data model.

Any ideas?

Excel 2016 32bit

Thanks
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
share file via OneDrive, GoogleDrive or any similar and post link to this file here
 
Upvote 0
Upvote 0
Very strange, I did Refresh and whole "your" table is loaded immediately

so maybe try re-build your Query from the beginning

btw.
screenshot-127.png
 
Upvote 0
Yep, I tried that as well previously (rebuilding from scratch). A bit frustrating but I guess I'll have to chalk this one up to a MS oddity.

Thanks for giving it a try!
 
Upvote 0
you are welcome
maybe:
- restart computer (old rule: if you have no choice - turn off / turn on :) )
- update office

btw. I did try with "Add this data to the Data Model" and it was loaded in a seconds
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,242
Members
452,623
Latest member
russelllowellpercy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top