Forum Discussion
Data Not Load power Query (Stucks)
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
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.
I am sharing the file for your reference.
https://parmarthsanstha-my.sharepoint.com/:u:/g/personal/satyamchaturvedi_parmarthsanstha_in/EXdYfsIe8PlKnws9O8ctw58BoRx5WDX1Hrtk6mVl9odkpg?e=xC8KwL