Forum Discussion
danextian
9 years agoSuper User
Exclude from refresh certain files for a folder data source
Hi All, I thought that it would be simpler to just connect to a folder instead of connecting to multiple files one by one and then appending them to a new query. It worked fine but I realized tha...
- 9 years ago
Well, I ended up separating my data sources into current and old folders. Thanks for this.
vanessafvg
9 years agoCommunity Champion
in power query you should be able to right click on the table and untick include in report refresh
danextian
9 years agoSuper User
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.