Forum Discussion
Loading huge files which does not exist...
Anyone has seen this before? I am loading from Power Query back to Desktop while the folder shown below has literally only 200 MB of data, it shows over 2 Gigabytes of data are processing tasks it almost a day to finish. I have set up the; Options to use less buffer and the other measures to make it fast but it did not work!
Help!
4 Replies
Hi Alirezam ,
Can u share your that folder which has 200 MB size. I would like to see whats wrong as I will try to load it in my Power BI Desktop to see whether same thing is happening in my case also or not. Only after that I can tell u what's the issue. If possible plz share it.
Hi Sushain, thanks for your kind help. Here is the link to the sources files. I have more from these folders making it entirely 200 MB. I am reckoning because of some XML files inside each folder this happens. However, when I run this in Power Bi Query it works smoothly but from Query to Desktop, it takes ages and ends up loading over GB!
Hi Alirezam
Have you checked the size of the following file? Is it possible that this file is too large ? You can move the file from the folder and then import the folder again , see if this situation still exists.
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Alirezam
Has your problem been solved ? If it has been solved, provide your method for the problem then consider Accept it as the solution to help the other members find it more quickly.
Best Regards
Community Support Team _ Ailsa Tao
