PowerBI desktop memory issue

[axata]

Hi, 

          I am using the MongoDB data source in powerbi. Its having a years of data into different tables which is containing the among 6 crore data. once i successfully load the data into the powerBi desktop.after that i use the union function formula to merge the all years data but its give me the memory related error. which is shown below:

[v-haibl-msft]

@axata

What is the RAM of your machine? It seems that your machine memory is not enough to do the union action. 

Maybe you can run PERFMON to check the memory usage and see if any other resource is problematic.

You can also try to increase your machine RAM or union less tables to see if memory issue persists.

Best Regards,
Herbert