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 ,
Just wanted to check if you had the opportunity to review the suggestions provided?
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

    Hi v-sdhruv  Thanks for checking.. No it hasn't resolved. I am courrently in process of trying to connect it with the database directly instead of the excel files. Will see how it works

    • 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.