Forum Discussion

Anonymous

Not applicable

5 years ago

Weird huge size loading

There are 2 data sets, Set1 is a single excel table, contains about 7000 rows 3 columns, size 164KB. 3 columns. ALL are text. Set2 is getting data from local disk folder, 19 excel files, 141MB i...

Need Help

V-lianl-msft

Community Support

5 years ago

This may be a problem with your M code.Please check the referenced columns and M code, and you can also refer to this blog to reduce waste of memory:

https://us.hso.com/blog/power-query-for-excel-load-settings-minimize-wasted-memory/

Anonymous

Not applicable

5 years ago

Emm, but I didn't see problem in M, anyway, thanks for reply.

Forum Discussion

Weird huge size loading

Related content

Approach to load huge data

Large Temp File when Loading a Huge Dataset

Build - Data field weird behavior

Efficient development with lean reports and huge Semantic Model

Dax Time Intelligence Functions Weird behavior - 13 Month Rolling Calc