Forum Discussion

UHS's avatar
UHS
Helper I
1 year ago
Solved

Insufficient Memory issue

Hi Everyone, Hope all are doing great. I am facing insufficient memory issue from past few days. I have a report with a size of 400 mb. Report is created on the basis of multiple excel files. I wa...
Need Help
Tips and Tricks
  • UHS's avatar
    UHS
    1 year ago

    v-sdhruv Thanks for yuor reply.. I have tried everything but still getting this issue. i am hopeing that moving the source to db and creating logical cols  there might help more. 

  • v-sdhruv's avatar
    v-sdhruv
    1 year ago

    Hi UHS ,
    If none of it worked then its better to pull it directly from data source and transforming it there.

    Because can  db can handle large volumes more efficiently and it would be less strain on Power BI’s memory model.

     

     

v-sdhruv's avatar
v-sdhruv
Community Support
1 year ago

Hi UHS ,
Sure that sounds like a great approach.
Meanwhile you can even try these-

1. Use 64-bit Power BI Desktop If you're on 32-bit, switch to 64-bit version.

2. Reduce columns with many unique values (e.g., timestamps, text IDs), they consume the most memory.

3. Avoid calculated columns — Use Power Query instead
Hope this helps!
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

UHS's avatar
UHS
Helper I
1 year ago

v-sdhruv Thanks for yuor reply.. I have tried everything but still getting this issue. i am hopeing that moving the source to db and creating logical cols  there might help more. 

  • v-sdhruv's avatar
    v-sdhruv
    Community Support
    1 year ago

    Hi UHS ,
    If none of it worked then its better to pull it directly from data source and transforming it there.

    Because can  db can handle large volumes more efficiently and it would be less strain on Power BI’s memory model.

     

     

  • v-sdhruv's avatar
    v-sdhruv
    Community Support
    1 year ago

    Hi UHS ,
    Did your issue got resolved or you need any assistance from our end?
    Please feel free to reach out incase of any issue.
    If your query got resolved, please mark the post  that helped you resolve your query as
    Accept as Solution so that other users can benefit from it.
    Thank You for being a part of Microsoft Community.