Forum Discussion

KD13's avatar
KD13
Helper I
4 years ago
Solved

Disable reload after each modeling step

Hi All,

 

I'm working on a large CSV file and i would like to stop reloading the model after each new modeling step as it's taking a lot of time.

 

Thanks for your support

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    KD13 , You can create some M parameter and filter the data in first them and later remove that. It should load only 1000 rows in power query, unless you use close and apply

    You can try first 2 setting, if they can help

     

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    KD13 , You can create some M parameter and filter the data in first them and later remove that. It should load only 1000 rows in power query, unless you use close and apply

    You can try first 2 setting, if they can help