Reply
JB Frequent Visitor
Frequent Visitor
Posts: 3
Registered: ‎04-08-2017
Accepted Solution

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


Accepted Solutions
Highlighted
Super Contributor
Posts: 1,334
Registered: ‎06-24-2015

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.

View solution in original post


All Replies
JB Frequent Visitor
Frequent Visitor
Posts: 3
Registered: ‎04-08-2017

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?

Super Contributor
Posts: 2,796
Registered: ‎08-14-2016

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

Highlighted
Super Contributor
Posts: 1,334
Registered: ‎06-24-2015

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.

JB Frequent Visitor
Frequent Visitor
Posts: 3
Registered: ‎04-08-2017

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

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