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.
Thanks so much. :smileyvery-happy:
PBI can be very cryptic with their error messages but your advice has solved a long term issue that I have been expereiencing.
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?
