Loading huge files which does not exist...

[Alirezam]

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!

[Anonymous]

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

[Anonymous]

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.

[SushainKoul]

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. 

[Alirezam]

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!

The source folder