Forum Discussion

Garymac1962's avatar
Garymac1962
Regular Visitor
1 year ago
Solved

Power Query refreshing after each applied step

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 i...
Need Help
  • pallavi_r's avatar
    pallavi_r
    1 year ago

    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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.