Forum Discussion

suvechha's avatar
suvechha
Helper IV
4 years ago

System.OutOfMemoryException

Hi there,

 

I am  getting an error System,OutOf Memory' and closing the Power BI App. I am unable to open the App. How to rsolve ?

Something went wrong

Exception of type ‘System.OutOfMemoryException’ was thrown

2 Replies

  • suvechha Try these steps:

    • Open file explorer
    • Right click on "My Computer"/"This PC" and select properties
    • Select "Advanced System Settings" from left-navigation panel. 
    • Click "Advanced" tab and "Settings" in the Performance section
    • Select "Adjust for best performance" in "Visual Effects" tab
    • Click "Change" in "Advanced" tab
    • Uncheck "Automatically manage paging file size" 
    • Select the drives and under custom size mention the size in multiple of thousands to set the size

    B.

  • v-jingzhang's avatar
    v-jingzhang
    Community Support

    Hi suvechha 

     

    Does this error still happen now? It usually occurs when your computer doesn't have enough memory space for Power BI to run. Close other unnecessary running applications/softwares will spare more memory for Power BI if this error just appear occasionally. 

     

    Also, if your table is in Import mode and you import a large amount of data into the model, it will consume much memory. You can use a small sample data when creating a report in Power BI Desktop. Then use query parameter to switch data source dynamically. After you complete the report and publish it to the service, you can change the query parameter to use the actual data source which has large data. See reference: Change the Source of Power BI Datasets Dynamically Using Power Query Parameters - RADACAD

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.