Kumar Shanmugam
Member
Using get data and transform I loaded 3 months CSV data and comibined the same through power query.

There are 20.10 lakh rows of data.
Data contains 39 columns.

I am facing a problem if i did data massaging after the above step.
For eg, I sorted the data by two columns and then tried to load the data into power pivot. After a certain point of applying query changes, I am getting low memory error.
I am using the latest version of Power BI. So no issue with the version of Power BI desktop.
I am using company provided laptop which has 64 bit intel core i3 4 GB Ram processor.
Is this due to server processor capacity issue? If Yes, is there any alternative solution like increasing the data load settings in power bi desktop.
Also unchecked the overall setting to optimise data modelling but this is also not working.

There are 20.10 lakh rows of data.
Data contains 39 columns.

I am facing a problem if i did data massaging after the above step.
For eg, I sorted the data by two columns and then tried to load the data into power pivot. After a certain point of applying query changes, I am getting low memory error.
I am using the latest version of Power BI. So no issue with the version of Power BI desktop.
I am using company provided laptop which has 64 bit intel core i3 4 GB Ram processor.
Is this due to server processor capacity issue? If Yes, is there any alternative solution like increasing the data load settings in power bi desktop.
Also unchecked the overall setting to optimise data modelling but this is also not working.