cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Super User III
Super User III

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 Super User!







Power BI Blog

View solution in original post

18 REPLIES 18
Highlighted
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?

Highlighted
Community Support
Community Support

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
If this post helps, please consider accept as solution to help other members find it more quickly.
Highlighted
Super User III
Super User III

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 Super User!







Power BI Blog

View solution in original post

Highlighted
Frequent Visitor

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

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

Highlighted
Resolver I
Resolver I

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 !

Highlighted
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

Highlighted
Super User III
Super User III

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 Super User!







Power BI Blog

Highlighted
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

Highlighted
New Member

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

 

 

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors