Model Stuck on Loading Screen after Applying Chang...

All tables load in PowerQuery perfectly fine and fast but when I close out and try to apply changes the model gets stuck at this loading screen and on the same excel file, that's not even big.

Certain nuiassances that may help in providing a solution to my problem:

-I have one table that I referenced alot to make 6 other tables (all are less than 64mbs) -These new created tables were used to create a large appended table, the only one I need loaded that gets stuck -The problem started when I created a 7th table that merged all the results from the other six table in order to do a summary "if" "or" statement between all the tables to determine if a "Yes" value exists across any of the rows; this was then appended to the original appended table.

-It also takes up 106GBs of desk space until 0 is left and never loads

-Sometimes an error of right instance specific key can not be determined pops up