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

     

Anonymous's avatar
Anonymous
Not applicable
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