Forum Discussion

DanFromMontreal's avatar
3 years ago
Solved

Prevent certain Query to be refreshed

Hello dear community, I need some advice to speed up the refresh.   I have 4 pretty large CSV file (A, B, C, D) that I load, transform and save as CONNECTION ONLY. After, a new Query (Combine all...
  • Fowmy's avatar
    3 years ago

    DanFromMontreal 

    Power Query doesn't store data, it has the steps to trasnform. When you referesh your data source/query, it executes the steps and load the data. Take a look at your transformation steps for optimization.