Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
PowerBI123456
Post Partisan
Post Partisan

Append Query Issues

I am trying to combine 3 seperate tables as append new query. I never had a problem before, but after recently, I have been having a lot issues. In power query, its loading all of the data for each step which is taking forever. When I go to apply changes, it gets stuck on evaluating forever as well.  Any help please! I never had this issue before. Here are my data settings:

 

PowerBI123456_0-1605561437443.png

 

11 REPLIES 11
v-easonf-msft
Community Support
Community Support

Hi, @PowerBI123456 

Could you please tell me whether your problem has been solved?
If yes,  you could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.

Best Regards,
Community Support Team _ Eason

@v-easonf-msft Hi  no its not been solved. Unfortuantely I cannot share screenshots since its private data. Nothing has changed, I was able to append the 3 datasets before and now having issues. 

v-easonf-msft
Community Support
Community Support

Hi, @PowerBI123456 

Does the issue only occur in this report?

Please share a related screenshot for further research.

 

Best Regards,
Community Support Team _ Eason

camargos88
Community Champion
Community Champion

@PowerBI123456 ,

 

Has the folder's location changed ? Is it a network path ?



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



@camargos88 Nope, nothing has changed. I can access this files fine. Only thing that changed was that I got the updated version of Power BI. Is there a way to stop all the data to load for every single step in power query. 

camargos88
Community Champion
Community Champion

@PowerBI123456 ,

 

What is your source ?



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



@camargos88 CVS files

camargos88
Community Champion
Community Champion

@PowerBI123456 ,

 

How are you doing it ? Append them on a new table ? 

Also, are you transforming something before the append function ?



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



@camargos88 Yes append as new. All transformation is done first and then I am apennding. I was doing this before and never had an issue. 

@PowerBI123456 ,

 

Has the volume data increased ?



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



@camargos88 Not really. But why is the full data loading from each table for each step? It never use to do that. 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

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.