cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Fatimah
New Member

Applied steps processing

I wish to know how the applied steps are being processed when refreshing a report on the desktop? arethey being processed in parallel or the next one starts after the one before it finishes? if they are being processed in parallel, is there a way to make them processed one by one?

 

7 REPLIES 7
d_gosbell
Super User
Super User

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.

v-binbinyu-msft
Community Support
Community Support

Hi @Fatimah ,

For import type connection, when you refresh the report:

1. Power BI Desktop will get the latestd data from datasource with Power Query Connector

2. then will apply the steps in Power Query Pane that you do

4. when all the steps execute completely, the data will load into Power BI, and all the report visual will refresh

 

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you for  your answer. 

I have one question regarding point number 2. are the steps in power query are being applied one by one or are thay being applies in parallel?

 


@Fatimah wrote:

Thank you for  your answer. 

I have one question regarding point number 2. are the steps in power query are being applied one by one or are thay being applies in parallel?

 


it could be either. It depends on the steps and the connector that you are using. It will do as much in parallel as it can.

is there a way to force it to process step by step?


@Fatimah wrote:

is there a way to force it to process step by step?


Why? You could possibly, manually insert Table.Buffer() calls into the code, but that will just make everything slower and consume way more resources than it should.

Helpful resources

Announcements
Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Kudoed Authors