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.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
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, 

 

The post on enabling/disabling parallel data load was very useful.  But in Excel 2016, the below option is unavailable and due to that my process is taking 4 times higher than earlier.  My process requires enabling the "Parallel loading of tables".