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 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.