Solved: Power BI Desktop automatic refresh queries one-by-... - Page 2

Anonymous · ‎04-08-2017

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

GilbertQ · ‎04-09-2017

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.

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

Proud to be a Super User!

Power BI Desktop automatic refresh queries one-by-one