Forum Discussion
Solved
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...
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
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.