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
Super User
6 years ago
Hi there

If you have a table that is referenced in Power Query it will have to load the data into the table in order to be able to load the data into a subsequent table.

That could possibly be why you are seeing them loading at the same time?
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi GilbertQ ,

 

thanks for your answer. I am not talking about the parallel processes shown in Power BI Desktop, i am talking about parallel processses running in the backend source system (in my case SAP BW).

When I am loading data from SAP BW to Power BI Deskop with unchecked parallel data loading it works as expected and there is only one process running in SAP BW.

If I am refreshing the same Power BI Applictation from Power BI Report Server there a several parallel processes in SAP BW running.

 

So I am wondering why my settings reagaring parallel loading are ingnored by the Power BI Report Server?!

 

Maybe someone has an idea...

 

BR & Thank you!

Andreas