Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Memory limit

Hi guys,   I have a PBIX file with 7 large data sets(around 2million rows and 20 columns per set ).I have deleted all the data that i could possibly not need to make them lighter so I dont hit memm...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , I am facing the same issue beyond 2.2 GB of file size. Few options to try

 

1. Increase Cache. File -> Options & setting -> Option -> Data load

2. Increase virtual memory of the system. Sometimes C drive does not have enough space to expand. if you other drive add Virtual memory there

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak I have done all te relevant amendments but the issue still instists.

 

My file is only 700MB.Do you think that getting a premium subscription change something?

 

Also,I am running Power bi from my Mac though Parallels but all the settings are in place for it to not get affected.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous 

    Here I will give you some advice.

    1. 

    Please try to turn off the 'relationship detect' options to disable auto detect the table relationships.

    For reference: Create and manage relationships in Power BI Desktop 

     

    2.

    If there are some date type column in your Sample. In the Options and setting disable Auto Date time option ,

    Refer to these setting: https://www.thebiccountant.com/speedperformance-aspects/

     

    3. 

    How many records are your data table hosted? Any complex expressions calculation(multiple iterators, nested cross table looping calculation ....) and advanced operation(merge, combine, reference, invoke custom functions, recursion...) existed in Dax or query editor side?

    For reference:

    Optimizing nested iterators in DAX 

    Recursive Functions in Power BI / Power Query 

    They may affect the performance and spend a huge amount of system resources.

    You can also take a look at the following document about performance tips:

    For reference: Optimization guide for Power BI 

     

    4. You can try to use Query Diagnostics or Performance Analyzer to monitor your Power BI performance.

    For reference: Monitor report performance in Power BI

     

    5. Please download the latest Power BI Desktop version and try again.

    Download by this link: Link

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Anonymous Unfortunately I havent been able to find a solution on this,I have an open ticket with the support team.I will update as soon as I hear from them.