Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Power BI Desktop automatic refresh queries one-by-one

Hi,   I have multiple queries and when refreshing, Power BI evaluate and refresh all queries at the same time. And some time, it crashs for memory issues or what ever reason. I may refresh the qu...
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi Anonymous

     

    There is a way to do this, in the Power BI Desktop click on File, Opions & Settings, then Options.

     

    Then once you see the options deselect Parallel Loading of tables as shown below.


     

    That will then not load the data in parallel but rather one at a time.

deepak_sk17's avatar
deepak_sk17
New Member
8 years ago

Hi Guavaq,

 

Very helpful. but in excel 2016, the below option of "Parallel loading of tables" option is removed.  And process requires, the refresh of tables need to be in parallel. Else it take more than 5 times it was taking me earlier.  Is there any option of enable the option.  Thanks you in advance.

 

Regards

Deepak

 

 

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
8 years ago
Hi there, I know that there is that option in Power BI Desktop, not sure if there

There is the option in Excel also once you open the Power Query Editor.