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
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Power BI Monthly Update - January 2026
Check out the January 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
