Power Query refreshing after each applied step

[Garymac1962]

I haven't seen this issue in another part of this forum. I am experiencing the following issue. When I refresh a Power Bi model, not only do each of the queries get refreshed, but each applied step in each query must go through a separate refresh process. 

In the model below, I have already done a full refresh by clicking "Refresh Preview" then "Refresh All". Here's where the problem starts. For example, in the Data query below, if I click on the first applied step (Source) Power Bi goes through the refresh process for just that step. Once that refresh is complete, clicking on the second applied step (Filter Rows2) causes the another refresh, and so on for every step in the query. Each one of these refreshes takes 2-4 minutes per applied step. 

This issue is occuring in many of my Power Bi models, but just started in the last two months. I would appreciate the community's help. 

Note: the source data for all of my Power Bi models are large Excel files.

Thanks,

Gary

[v-pbandela-msft]

Hi @Garymac1962,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly accept it as a solution and give it a 'kudos' so others can find it easily.

Thank you,
Pavan.

[v-pbandela-msft]

Hi @Garymac1962,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

[v-pbandela-msft]

Hi @Garymac1962,

Thank you for reaching out in Microsoft Community Forum.

Thank you @pallavi_r   for the helpful response.

As suggested by Pallavi_r,  I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.

Please continue using Microsoft community forum.

Regards,
Pavan.

[pallavi_r · Accepted solution]

Hi @Garymac1962 ,

You can try out these: 

a. Uncheck Allow data previews in the background

or b) disable loading here

Effective one is to add parameter to limit the data by keeping only top few records except full. Write a power query step with conditional logic to keep limited or full data.  Please check the step by step approach from Guy in a cube video.

https://www.youtube.com/watch?v=_zYvybVMk7k

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi