Forum Discussion
Power BI Desktop automatic refresh queries one-by-one
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.
I am unchecking the option Enable Parrallel loading of tables but this is not working and both my tables are loading in parrallel. My data source is two tables from Sql Server.
Hello Murtuzahm ,
we are experiencing some similar behaviour. If I am unchecking the "Enable Parrallel loading of tables" it works fine in PBI Desktop but if I am publishing the report to the report server and scheduling a job there it ingnores the setting an loads in parrallel.
Did you find a solution for this in the meantime?
Thank you,
Andreas
- GilbertQ
Super User
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?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