September 29, 2020
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.
July 16, 2010
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;
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.