Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)

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? 

1 Answer

0 votes
by (22.5k points)

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

Related questions

0 votes
1 answer
asked Jan 6, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Browse Categories

...