Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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.

Anonymous
Not applicable

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors