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