Forum Discussion
Exclude from refresh certain files for a folder data source
Well, I ended up separating my data sources into current and old folders. Thanks for this.
in power query you should be able to right click on the table and untick include in report refresh
Hi vanessafvg,
Doing that would make sense if I connected to a file directly. But I am connecting to a folder with multiple files. Some of the files, like past years' data, no longer need to be refreshed as they will no longer be updated. I want to exclude them from the refresh. Just those files.
Those files are quite big and I want to save time from refreshing them since their data in the model don't need to be updated.
so what you saying is you combine data? if you combine data into one table from different files i dont think there is a way to remove the refresh from it individually.
The only thing you could do is create a new folder for data you dont refresh and then append it to the refreshable files.