Forum Discussion
Satyam_chaturvedi
Aug 21, 2022Copper Contributor
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
2 Replies
- SergeiBaklanDiamond Contributor
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.
- Satyam_chaturvediCopper Contributor
I am sharing the file for your reference.
https://parmarthsanstha-my.sharepoint.com/:u:/g/personal/satyamchaturvedi_parmarthsanstha_in/EXdYfsIe8PlKnws9O8ctw58BoRx5WDX1Hrtk6mVl9odkpg?e=xC8KwL