Forum Discussion

LYorkToenniges's avatar
LYorkToenniges
Helper III
2 years ago
Solved

Power BI closing without warning, no error message

Power BI is closing when I go into Power Query to refresh my tables.  I have expanded the memory allocation in options, reduced the loading to 1 at a time, and turned off auto time etc.  I have alrea...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi LYorkToenniges ,

     

    Please try disabling background data refresh to prevent changes from triggering an automatic refresh while you make changes. You can do this by going to File > Options and settings > Options > Current File > Data Load and unchecking Background Data.
    And instead of refreshing all queries at once, try refreshing them individually. In Power Query Editor, you can right-click on a query and select Refresh Preview.

     

    Hope it helps！

     

    Best regards.
    Community Support Team_Caitlyn

     

muhssamy's avatar
muhssamy
Resolver I
2 years ago

You should use windows performance monitor tool to track memory and cpu

this video can explain how to use it

 

https://youtu.be/O0U3am0aBss?

 

Then you will understand what is going on

 

alao be sure that you have latest updates 

  • LYorkToenniges's avatar
    LYorkToenniges
    Helper III
    2 years ago

    Thank you very much.  I am definitely up to date with updates.  I am very sure it is the limitations on how much a non-premium account can load but I do not have the option of switching as the company does not have any liscences available.  Ways to modify the loading of data may be my only option to save the file.

    • muhssamy's avatar
      muhssamy
      Resolver I
      2 years ago

      No. it is not related to your licence this is only related to your local development Machine/ PC

       

      just monitor what is going on and let us know me be we can help here

      • LYorkToenniges's avatar
        LYorkToenniges
        Helper III
        2 years ago

        This is what I could get.  Please let me know if there are other counters I should add.  I was a little overwhelemed by the options.  the dip right before 4:15p is the crash.