Log In
Register
Home
New Member
September 29, 2020
Offline
Hi there,
I am trying to load a query that is referencing 14 other queries in Power Query Editor however it has taken over 40 mins up to now and still so signs of loading. I am able to load the other 14 individual queries but not the "master" query that acts as the central source.
I have been reading other forums which say to go Query Options>Data Load>Background Data then untick "Allow data preview to download in the background". Having unticked this box I receive an error message on the "master" query stating "Unexpected Error: Evaluation was cancelled".
I am fairly new to power query and have not come across this issue before so any help would be greatly appreciated.
Thanks
July 16, 2010
Offline
Hi Warren,
Welcome to our forum. I haven't experienced this problem before, but a Google search brought up these threads which might point you in the right direction;
https://social.technet.microso.....powerquery
https://community.powerbi.com/.....td-p/43470
You haven't said what version of Excel/Power BI you're using, but I'd update Power Query if you can as it may be a bug in an earlier release.
Mynda
1 Guest(s)
