Forum Discussion
Applied steps processing
It depends a bit on what steps are being processed, but as a general rule Power BI will attempt to "fold" as many steps as possible down to the data source.
So if you did the following against something like a SQL database:
Step 1- select columns
Step 2 - filter
Step 3 - sort
Then power query will generate a single SQL statement that does all 3 steps as a single query.
Fatimah wrote:
if they are being processed in parallel, is there a way to make them processed one by one?
The bigger question is why you would want to do this? It will make the whole process slower and less efficient.
Thank you for your repley. Actually, thie thing is that I have a report with too many steps and I am unable to refresh it and I do belive that the reason is that because there is a step is takeing too lng to be processed so the Power BI goes to then next step and the next step needs an outcome from the step before so in this way the update fails. That is why I need the to process the steps one by one.
