Data Not Load power Query (Stucks)

Copper Contributor

Hii

I Have connected 63 Worksheet in power query with Append Option but the data does not load I am Awaited 3 Hours.

please guide for a solution.

Satyam

2 Replies

@Satyam_chaturvedi 

It's hard to discuss performance without concrete file. Some general tips are here Speed/Performance aspects – The BIccountant

In your situation be sure tables are optimised before appending. 

@Sergei Baklan 

 

I am sharing the file for your reference.

 

 

Snap Excel .pngExcel File