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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Kudoed Authors