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,

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.