Exception of Type System.OutOfMemoryException was thrown when unpivoting tables in PowerBI

Question

I am trying to create a column in Power Bi,I can able to create 1 or more columns and beyond that i get an error

Exception of Type System.OutOfMemoryException was thrown when unpivoting tables in PowerBI

How can I solve this? 

Answer 1

1. Select file folder

2. Right click on My Computer and click on properties.

3. Go to Advanced System Settings which is in left-navigation panel. 

4. Select Advanced tab. 

5. Go to Settings in Performance section. 

6. Click on Adjust for best performance which is in "Visual Effects" tab. 

7.  Change to Advanced tab. 

8. Untick Automatically manage paging file size 

9. Select the drives (preferably SSD) . minimum to 16000 and maximum to 32000

Want to learn more about Power Bi, Refer: Power Bi Training