cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JB Frequent Visitor
Frequent Visitor

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 queries one-by-one manually but it implies to stay in front of the file.

Is there no "automatic" refresh button or script which could refresh the various queries one after each other?

 

Thanks for your tips

 

JB

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Power BI Desktop automatic refresh queries one-by-one

Hi @JB

 

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.


Power BI - Parallel Loading.png

 

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



Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
15 REPLIES 15
JB Frequent Visitor
Frequent Visitor

Desktop PowerBI refresh one-by-one instead of all queries refresh in parallel

I have multiple queries.

When pushing "refresh button", all queries are evaluated and refreshed at the same time.

It may result "crash" due to memories.

Would it not be possible to run the queries one by one, sequentially?

Obviously, i can run the queries one-by-one manually but I would like an automatic refresh button which can refresh these queries one-by-one.

Possible?

Community Support Team
Community Support Team

Re: Power BI Desktop automatic refresh queries one-by-one

Hi @JB,

 

Current power bi seems not support refresh one by one. I'd like to suggest you can post your requirement to ideas to help improve power bi.
Perhaps you can vote below ideas which has the similar requirement:

Refresh priorities

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Super User
Super User

Re: Power BI Desktop automatic refresh queries one-by-one

Hi @JB

 

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.


Power BI - Parallel Loading.png

 

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



Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
JB Frequent Visitor
Frequent Visitor

Re: Power BI Desktop automatic refresh queries one-by-one

Thank you Guavaq.  It makes it and no crash any more.

ketan10 Regular Visitor
Regular Visitor

Re: Power BI Desktop automatic refresh queries one-by-one

Hi @GilbertQ 

Is there a way to do this in 'EXCEL' ? I could not find the 'Enable parallel loading of tables' in Excel ? 
I have certain number of tables which I want them to load in a particular order.

Example: I have two tables:

Table 1
Table 2

 

Now, I want the Table 2 to be loaded only after Table 1 is loaded completely (i.e it should not refreshed parallely)

Any help or workaround for this in 'EXCEL' would be appreciated.

Thank you !

martinhyy Frequent Visitor
Frequent Visitor

Re: Power BI Desktop automatic refresh queries one-by-one

Hi @GilbertQ

 

Does this also mean when I publish the report onto the PowerBI server and schedule the refresh, the server will also do the same thing -- refreshing the query one by one?

 

Thanks

Super User
Super User

Re: Power BI Desktop automatic refresh queries one-by-one

Hi @martinhyy

 

I am not 100% sure, it might possibly keep what ever settings you have in place when refreshing the data.



Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
martinhyy Frequent Visitor
Frequent Visitor

Re: Power BI Desktop automatic refresh queries one-by-one

Hi @GilbertQ

 

Just tested. Seems to be working somehow, but I'm not sure how the data is refreshed in the backend.

 

Thanks

deepak_sk17 Frequent Visitor
Frequent Visitor

Re: Power BI Desktop automatic refresh queries one-by-one

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".