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.

     

     

lbendlin's avatar
lbendlin
Super User
1 year ago

How much RAM do you have on your PC, and how much of it did you allow Power BI Desktop to use?

UHS's avatar
UHS
Helper I
1 year ago

I have 16 gb ram in my PC, 64 bit OS and we allow 450 mb to power bi.. yesterday i tried to change it to 1000 mb in power bi but still got the memory error. Report is running fine in the power bi service but in desktop version i am getting issues after adding more data.. Now its getting so slow that when i have to create any new measure or col it take 1-2 minutes to let me do that. IS ther eany way i can resolve it